TM1 Forum

Long time no post, but it's good to be back!

I'm getting my feet (fingers?) wet in Planning Analytics using multiple hierarchies and am having trouble with something that should be super simple. I'm trying to write a rule with a call to an alternate hierarchy, with an ELISANC statement as such:

IF(ELISANC(['CoCCAcct':'PL Account'],['CoCCAcct':'PL Account':'Net Revenue'],!CoCCAcct) = 1,...

And I'm getting the old faithful "invalid string expression" error. What am I missing?

Looks like you may be mixing rules and MDX/Other.
You probably need something like: Edit: Still having trouble understanding how the new multiple hierarchies are different to any other pre-PA implementation where you created multiple hierarchies in a dim by having multiple root elements and rolling up N levels into C levels as required. Excuse the response above if my ignorance is misleads. I will need to spend a lot more time trying to understand how these new hierarchies differ and where they apply.

According to the new Reference Guide, it looks like ELISANC is the hierarchy-less version. If you want to use one and specify a hierarchy, it seems the new rule is "ElementIsAncestor".

Thank you jwilliamson_uci, I'll try that! I suppose I should look at the reference guide instead of just expecting everything to work .

RTFM