Hey there,
I have a request with i cant find information about:
In a Dimension in Performance Modeller (10.2.2.0) i want to use the "Level" Attribute in a TI Process. I know that with ELLEV i can use the Level from an Element but with ELLEV I get the Level from Architect with is different to the one on PM (See attached Screenshot).
Any hints on this would be great!
Thanks
Using "Level" Attribute from Performance Modeller in a TI Script
-
- Posts: 15
- Joined: Mon Mar 14, 2016 9:14 am
- OLAP Product: TM1
- Version: 10.2.2.0
- Excel Version: 2013
Using "Level" Attribute from Performance Modeller in a TI Script
- Attachments
-
- Levels.jpg (83.33 KiB) Viewed 3770 times
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Using "Level" Attribute from Performance Modeller in a TI Script
As far as I'm aware the level returned ElLev is level recognized by the server software. The one displayed in PM isn't valid (for you are trying to do) at execution time so it shouldn't make a difference.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 15
- Joined: Mon Mar 14, 2016 9:14 am
- OLAP Product: TM1
- Version: 10.2.2.0
- Excel Version: 2013
Re: Using "Level" Attribute from Performance Modeller in a TI Script
So far so good but my customer needs the "Level" Strings as own Attribute in the Dimension.
He wants to use the String "Ebene x" as separate Number in an Attribute (see "LevZahl").
I've attached it visually for better understanding...
Thanks!
He wants to use the String "Ebene x" as separate Number in an Attribute (see "LevZahl").
I've attached it visually for better understanding...
Thanks!
- Attachments
-
- Level Explanation.png (37.02 KiB) Viewed 3747 times
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Using "Level" Attribute from Performance Modeller in a TI Script
There's nothing stopping you from creating your own attribute and populating it with whatever you want. You don't have to use the internal levels that are part of TM1.Ptec wrote:So far so good but my customer needs the "Level" Strings as own Attribute in the Dimension.
-
- Posts: 15
- Joined: Mon Mar 14, 2016 9:14 am
- OLAP Product: TM1
- Version: 10.2.2.0
- Excel Version: 2013
Re: Using "Level" Attribute from Performance Modeller in a TI Script
I've found a solution .
I'm counting the Elpar's of an Element in a while loop.
Also I set a counter for the amount of Parents of an Element - this counter represents the "Level Name" in PM.
So I can set the counter Number as Attribute for the requested Attribute "LevZahl".
At the End of the put ATTRS command in the loop, I'm resetting the counter and starting the While Loop again - as long as the amount of Elements in the Dimension.
I think that's the best solution for the Request...
I'm counting the Elpar's of an Element in a while loop.
Also I set a counter for the amount of Parents of an Element - this counter represents the "Level Name" in PM.
So I can set the counter Number as Attribute for the requested Attribute "LevZahl".
At the End of the put ATTRS command in the loop, I'm resetting the counter and starting the While Loop again - as long as the amount of Elements in the Dimension.
I think that's the best solution for the Request...
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Using "Level" Attribute from Performance Modeller in a TI Script
Be careful with ELPARs. That function takes a Tree # parameter. If you only have one tree in the dimension then you just supply a 1 and you are good to go. If you have more than one tree then your solution may not work. That's because the Tree # property assigned by TM1 is not always consistent and just using a 1 could lead to some weird results in your TI.