Page 1 of 1
Using "Level" Attribute from Performance Modeller in a TI Script
Posted: Wed May 25, 2016 10:32 am
by Ptec
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
Re: Using "Level" Attribute from Performance Modeller in a TI Script
Posted: Wed May 25, 2016 11:59 am
by jim wood
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.
Re: Using "Level" Attribute from Performance Modeller in a TI Script
Posted: Wed May 25, 2016 1:36 pm
by Ptec
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!
Re: Using "Level" Attribute from Performance Modeller in a TI Script
Posted: Wed May 25, 2016 1:42 pm
by tomok
Ptec wrote:So far so good but my customer needs the "Level" Strings as own Attribute in the Dimension.
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.
Re: Using "Level" Attribute from Performance Modeller in a TI Script
Posted: Wed May 25, 2016 1:53 pm
by Ptec
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...
Re: Using "Level" Attribute from Performance Modeller in a TI Script
Posted: Wed May 25, 2016 2:45 pm
by tomok
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.