TM1 Forum

Dear All
How to using group of element in rules / subset in rules.
I would like to create rule like this.


['G_NONE', 'THB', 'AUD21101 IC ELIM', 'IC_PL_OTHERS' ] = N:
DB('CONSOLIDATION', 'ACCOUNT':{'51010000','51020000'} , !ENTITY, !FLOW, !INTERCO, !RPTCURRENCY, !SCOPE, !TIME, !VERSION, !MEASURES);

I would like to summary amount of Account '51010000','51020000' and post to Account 'IC_PL_OTHERS'.

I can't using subset in rule.

Thanks in advanced

I can't using subset in rule

It is perfectly alright to use subsets in rules,Please go below links:
http://www.tm1forum.com/viewtopic.php?p=41083

http://www-01.ibm.com/support/knowledge ... ion_N701DF

BariAbdul wrote:

I can't using subset in rule

It is perfectly alright to use subsets in rules,Please go below links:
http://www.tm1forum.com/viewtopic.php?p=41083

http://www-01.ibm.com/support/knowledge ... ion_N701DF

This link refers to using a group of elements in the left hand side of the rule; I believe the OP is looking for how to do the equivalent on the RIGHT hand side.
In which case you can either create a consolidation of 51010000 and 51020000 and use the consolidation in the rule or you can just do the DB of 1 plus the DB of the other (or square bracket short hand if its the same cube.)

Thanks you.
You mean we have 2 Methods like these ?
1. Create Consolidation Node and Add ACCOUNT to that node
2. Create Rule like [ 'IC_PL_OTHERS' ..] = N: [ '510000' ... ] + ['512000' ...].

declanr wrote:

BariAbdul wrote:

I can't using subset in rule

It is perfectly alright to use subsets in rules,Please go below links:
http://www.tm1forum.com/viewtopic.php?p=41083

http://www-01.ibm.com/support/knowledge ... ion_N701DF

This link refers to using a group of elements in the left hand side of the rule; I believe the OP is looking for how to do the equivalent on the RIGHT hand side.
In which case you can either create a consolidation of 51010000 and 51020000 and use the consolidation in the rule or you can just do the DB of 1 plus the DB of the other (or square bracket short hand if its the same cube.)

Yes, correct.