TM1 Forum

I hate it when people ask this question but I just have to do it : "Why would ya want to do that?" The TM1 GUI (Excel & Perspectives) is essentially a super-charged Pivot Table. Kinda like choosing to hand-wash a basket of clothes when you have a brand-new washing-machine right next t...

Telula,

Reading your post a 2nd time maybe your "All Active Contracts" consolidation already exists? In which case all you need to do to your MDX is:

{ TM1DRILLDOWNMEMBER( { [Contract].[All Active Contracts]}, ALL, RECURSIVE ) }

Hi Telula, I think you might be confusing subsets and hierarchies. Although it is a "hidden feature" of TM1 that you can use a subset name in a DBRW formula which will act like a user defined consolidation this may or may not be what you are after. It's probably "dangerous" to us...

It is a bit difficult to say, I thought I knew what your problem was but the more I reread your post the more I am confused by what you are saying. So rather than posting a hypothetical solution based on guesswork maybe some further questions will help you out .. 1. Is the pseudo-navigation replacin...

TM1 never releases memory back to the OS but it does internally recycle it's own pool of "garbage memory"

Leaf holds simple yes. Distinguishing between blank and zero cell values definitely not, especially when also involving Undefvals. My understanding is that when Undefvals is used in a cube's rule file then if a zero value is entered into a cell or a value is zeroed out then TM1 will distinguish betw...

... disappointing as I thought they sorted this issue out in 9.1.4 This might be a kludgy workaround but no reason why it wouldn't work. Have a control cube that lists by time blocks and days of the week when your intra day chore should run, check on the prolog of the first process whether the intra...

But once the decision aboout the software is made, we have to get the best of it. ... and to get the best out of TM1 the approach may be very different from other systems! It might pay to get some good training and advice on TM1 cube and report design. One of the problems with this tool is that it ...

If the description attribute is an alias then you can use SubsetAliasSet( DimName, SubName, AliasName ) in TI to set an alias to use in the subset definition.