TM1 Forum

Hi,

Which activity causes stargate view removal?

Doesn't updating the VMM and VMT properties to values where they are unlikely to cache also remove stargate views?

regards,

Mark

Hi, I have not used this myself but I believe you enter the relevant directories, separated by a comma in the cfg file, like so, DatabaseDirectory="c:\tm1dims;c:\tm1cubes" The documentation stresses that this does the following: Accesses cubes and dimensions from each of the specified dire...

Hi,

I would add that DimensionElementInsert also allows you to specify the Insertion point.

regards,

Mark

Hi, Don't think anything new in planning Analytics solves this, so the old method should still work. Create a new measure called MinusValue Rule for MinusValue is: ['MinusValue']=N: IF(['B']<0,1,0); Create a new measure called NatLog Rule for NatLog is: ['NatLog']=N:IF(['B']<>0, LN(ABS(['B'])),0); R...

Hi, I ran into this issue in 2021, as per this link on the IBM forum: https://community.ibm.com/community/user/businessanalytics/discussion/workspace-dynamic-mdx-in-dimension-dragged-outside-cube-view I was hoping for a synchronisation solution by now! having said that when you say, Sometimes simple...

Hi, I have started to use DefineCalc in custom reports and to my dismay they cannot be used in websheets, which means that for most of the organisations I know, where reporting is done via PAW and everything is done formally, DefineCalc is next to useless. It seems to have been designed with an acco...

Hi Steve, Oh agreed, the IBM solution is so simple as to be useless but it does give the starting point to try and come up with some clever looping/cube solution. Obviously your RFE is the not only desirable but pretty essential given how Planning Analytics has developed over the last few years. reg...

Hi Steve, Sorry missed your reply from the 30th May: Something that's not clear in the explanation I had or your one, is if it is actually possible to refactor the MDX such that what we want to do is possible? I think not but would be happy to be wrong.... Well, I would say yes and no. No in that yo...

Hi, I raised a case (TS012607330) recently re the Planning Analytics Admin agent and high cpu usage on some of our environments (but not all environments). They advised us after providing all relevant logs and other information, to check "Power setting in OS , BIOS and Hypervisor (if this is VM...

Hi, I raised an issue view ViewCreateByMDX and ViewZeroOut with IBM some time ago. After a long and protracted period of time, this was their ultimate response: After discussing this with my internal team I would like to provide you an explanation that this works by design. Due to the current way th...

Cheers Wim, I wasn't aware of the mystery 3rd parameter, and useful to know.

I should have read George Tonkin's MDX guide a bit more closely! That one went right over my head.

Hi,

Just for info, I have moved away from using TM1FILTERBYPATTERN because it can't handle aliases.

The following topics describe the issues, and the workarounds using the INSTR function.

regards,

Mark

Hi,

think this was discussed in more depth here:

https://www.tm1forum.com/viewtopic.php?t=15488

regards,

Mark

Hi keith,

I deleted my comment as I knew it was wrong. It has been a long day!

I was going to suggest you numbertostring pPayrollPeriodNumber but I think you are now saying it works ok.

regards,

Mark

Hi Wim,

the more relevant topic is this one, as this is the topic that I think triggered George's post on the community:

https://www.tm1forum.com/viewtopic.php?t=16193

regards,

mark

Hi George,

Another wow from me! Just wished you had shared this like 5 years ago!

I knew about all the others except the VAL, though I don't see much need to use UCASE and LCASE since you pointed out the 4th parameter of INSTR could be used to turn off case sensitivity!

regards,

Mark

Hi, You could also skip the additional excel cell and just put lcase around A2 also (in the MDX formula) - just for the benefit of keeping all of the "logic" in 1 place. Oh yeah! ;) Just did a quick test. You are right, PAW is completely case insensitive and accepts upper or lower case for...

Hi, One small wrinkle though if the lookup cell value is bob (lower case) instead of Bob this doesn't work. I'd have to account for users typing in either I imagine. for PAX sheet, imagine cell A1 contains the search text, e.g. Bob To cater for lower or upper or any case input by the users you can d...

Hi, I am going to play slight devils advocate in response to Tomok, even though I generally agree with his points. I tend to regard finance as the low hanging fruit when it comes to Planning Analytics. However, in my experience, and depending on the organisation, there is plenty of scope for utilisi...

Hi, You may have to rethink this and create a subset for each New Loan, so let us say for each new loan you create a subset prefixed with EndMonths_ and then the name of the loan, e.g. New Loan 1 subset would = EndMonths_New Loan 1 The MDX in the EndMonths_New Loan 1 would be: {FILTER(TM1FILTERBYLEV...