TM1 Forum

Hi
When I am trying to consolidate immediate children I am not getting the value at parent level element, please find the attachment,in which it has cube and rule written.
The consolidate value at the next level is happening, that is if [{'Quarter1','Quarter2','Quarter3','Quarter4'}]=1 is working when i write rule like shown in the attachment,
I am getting N/A at the year element.please help me

TM1 9.5.2
excel 2007

Why are you prefacing the Year calculation rule with an "N:"?

tomok wrote:Why are you prefacing the Year calculation rule with an "N:"?

Tomok is right the rule isn't getting applied because you have given it an N: filter and as Year is a consolidation there are no leaf cells to apply the rule to and hence it is ineffective.

But another question would be why are you setting these rules up at all? The hierarchies in the Month and Region dimensions will naturally perform these consolidations without any need for rules and with much greater performance.

thank you.
I was trying with consolidate children syntax.