Finding all of the top level heirarchy/consolidated elements

[RJ!]

Hi All,

I'm trying to write a rule that effectively "hides" all of our legacy Cost Centres from our users by updating the Element Security Cube relating to the Responsibility Centre.
So the logic for the rule is:
If the Responsibility Centre is in the "Legacy RC" consolidation & the Responsibility Centre does not exist in any of the other 6 Consolidations, change the access to "NONE" otherwise leave as "WRITE".

My preference is not to hard code the names of the 6 Consolidations into the rule when I check that the RC does not exist in them with an ELISPAR formula.

Does anyone know if it's possible to have TM1 determine the 6 Consolidations? I thought about the MDX function "TopCount" but the total number of consolidations might change from the current 6...

[Alan Kirk]

Hi All,

I'm trying to write a rule that effectively "hides" all of our legacy Cost Centres from our users by updating the Element Security Cube relating to the Responsibility Centre.
So the logic for the rule is:
If the Responsibility Centre is in the "Legacy RC" consolidation & the Responsibility Centre does not exist in any of the other 6 Consolidations, change the access to "NONE" otherwise leave as "WRITE".

My preference is not to hard code the names of the 6 Consolidations into the rule when I check that the RC does not exist in them with an ELISPAR formula.

Does anyone know if it's possible to have TM1 determine the 6 Consolidations? I thought about the MDX function "TopCount" but the total number of consolidations might change from the current 6...

You could base the test on:
- ElIsPar to check whether the cost centre is in Legacy RC; and
- ElParN to check the number of parents.

If the first returns 1 to show that it's in that consolidation, and the second returns 1 (meaning that it's ONLY used in that consolidation), then you know it's one that you want to hide. Otherwise, it's one that is still in a "live" consolidation, regardless of the name of that consolidation. (And regardless of whether the 6 become 7 or 8 or whatever at some time in the future.) Then the only thing that you need to keep constant is the name of the Legacy RC consolidation.