Planning Analytics Local 2.0: Rules Calling Multiple Hierarchies

Post Reply
tstroumbos
Posts: 18
Joined: Tue Jul 31, 2012 5:10 pm
OLAP Product: IBM Cognos TM1
Version: Planning Analytics 2.0
Excel Version: 2013
Location: Bend, OR

Planning Analytics Local 2.0: Rules Calling Multiple Hierarchies

Post by tstroumbos »

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?
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Planning Analytics Local 2.0: Rules Calling Multiple Hierarchies

Post by gtonkin »

Looks like you may be mixing rules and MDX/Other.
You probably need something like:

Code: Select all

IF(ELISANC('PL Account','Net Revenue',!CoCCAcct) = 1,...
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.
Last edited by gtonkin on Thu Jun 22, 2017 6:27 am, edited 1 time in total.
jwilliamson_uci
Posts: 4
Joined: Wed Dec 08, 2010 11:32 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: Excel 2013

Re: Planning Analytics Local 2.0: Rules Calling Multiple Hierarchies

Post by jwilliamson_uci »

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".
tstroumbos
Posts: 18
Joined: Tue Jul 31, 2012 5:10 pm
OLAP Product: IBM Cognos TM1
Version: Planning Analytics 2.0
Excel Version: 2013
Location: Bend, OR

Re: Planning Analytics Local 2.0: Rules Calling Multiple Hierarchies

Post by tstroumbos »

Thank you jwilliamson_uci, I'll try that! I suppose I should look at the reference guide instead of just expecting everything to work ;).
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Planning Analytics Local 2.0: Rules Calling Multiple Hierarchies

Post by Wim Gielis »

RTFM ;-)
Best regards,

Wim Gielis

IBM Champion 2024
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
Post Reply