Using "Level" Attribute from Performance Modeller in a TI Script

Post Reply
Ptec
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

Post 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
Attachments
Levels.jpg
Levels.jpg (83.33 KiB) Viewed 3741 times
User avatar
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

Post 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.
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
Ptec
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

Post 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!
Attachments
Level Explanation.png
Level Explanation.png (37.02 KiB) Viewed 3718 times
tomok
MVP
Posts: 2831
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

Post 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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Ptec
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

Post 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...
tomok
MVP
Posts: 2831
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

Post 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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply