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 ) }
Search found 3508 matches
- Mon Mar 23, 2009 3:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: dynamic subset with new consolidation name
- Replies: 2
- Views: 3411
- Mon Mar 23, 2009 3:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: dynamic subset with new consolidation name
- Replies: 2
- Views: 3411
Re: dynamic subset with new consolidation name
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...
- Tue Mar 17, 2009 10:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1web: SUBNM with "living" subset
- Replies: 2
- Views: 3382
Re: TM1web: SUBNM with "living" subset
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...
- Mon Mar 16, 2009 10:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 9.4 MR1
- Replies: 13
- Views: 7714
Re: TM1 9.4 MR1
TM1 never releases memory back to the OS but it does internally recycle it's own pool of "garbage memory"
- Mon Mar 16, 2009 11:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: A couple of simple questions - cube manipulation
- Replies: 11
- Views: 6939
Re: A couple of simple questions - cube manipulation
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...
- Sat Mar 14, 2009 4:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 9.4 MR1 Crash when chores queue up
- Replies: 5
- Views: 4170
Re: TM1 9.4 MR1 Crash when chores queue up
... 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...
- Fri Mar 13, 2009 11:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel / Websheet cell dependencies
- Replies: 5
- Views: 5828
Re: Excel / Websheet cell dependencies
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 ...
- Fri Mar 13, 2009 11:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX return attibute
- Replies: 5
- Views: 5500
Re: MDX return attibute
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.