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
How to using group of element in rules
-
- Posts: 8
- Joined: Thu Feb 21, 2013 11:27 am
- OLAP Product: TM1, SAP BW
- Version: 9.5.2
- Excel Version: Excel 2010
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: How to using group of element in rules
It is perfectly alright to use subsets in rules,Please go below links:I can't using subset in rule
http://www.tm1forum.com/viewtopic.php?p=41083
http://www-01.ibm.com/support/knowledge ... ion_N701DF

"You Never Fail Until You Stop Trying......"
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: How to using group of element in rules
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.BariAbdul wrote:It is perfectly alright to use subsets in rules,Please go below links:I can't using subset in rule
http://www.tm1forum.com/viewtopic.php?p=41083
http://www-01.ibm.com/support/knowledge ... ion_N701DF
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.)
Declan Rodger
-
- Posts: 8
- Joined: Thu Feb 21, 2013 11:27 am
- OLAP Product: TM1, SAP BW
- Version: 9.5.2
- Excel Version: Excel 2010
Re: How to using group of element in rules
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' ...].
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: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.BariAbdul wrote:It is perfectly alright to use subsets in rules,Please go below links:I can't using subset in rule
http://www.tm1forum.com/viewtopic.php?p=41083
http://www-01.ibm.com/support/knowledge ... ion_N701DF
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.)
-
- MVP
- Posts: 3240
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: How to using group of element in rules
Yes, correct.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly