Rule to all member of certain Consolidation

Post Reply
aztec
Posts: 2
Joined: Wed Mar 21, 2012 8:56 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Rule to all member of certain Consolidation

Post by aztec »

Hi all,

I need help a little bit.
- Do you all know how to apply rule to all child in a certain consolidation?
Exp: Dim X
Consold A
Child 1
Child 2
Child 3
Etc
Consold B
Child 1
Child 2

I only need to apply rule to all child at consold A (apply all at once, cause element inside Consold A keep increase from time to time)
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Rule to all member of certain Consolidation

Post by qml »

Example:

Code: Select all

[] = N: IF ( ELISPAR ('Dim_X', 'Consold A', !Dim_X) = 1,
<rest of your rule>,
STET );
Kamil Arendt
aztec
Posts: 2
Joined: Wed Mar 21, 2012 8:56 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Rule to all member of certain Consolidation

Post by aztec »

thanks a lot man, :D :D
Post Reply