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?
Planning Analytics Local 2.0: Rules Calling Multiple Hierarchies
-
- 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
- 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
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.
You probably need something like:
Code: Select all
IF(ELISANC('PL Account','Net Revenue',!CoCCAcct) = 1,...
Last edited by gtonkin on Thu Jun 22, 2017 6:27 am, edited 1 time in total.
-
- 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
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".
-
- 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
Thank you jwilliamson_uci, I'll try that! I suppose I should look at the reference guide instead of just expecting everything to work .
-
- 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
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
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