TM1 10.2.2 Performance Modeler Cloud

Post Reply
andyhofer
Posts: 3
Joined: Sun May 03, 2015 5:44 pm
OLAP Product: 10.2.2
Version: 10.2.2
Excel Version: Excel 2010 2013

TM1 10.2.2 Performance Modeler Cloud

Post by andyhofer »

Hi all

I'm just starting to use TM1 and moving away from Cognos Enterprise Planning (EP). Is there a specific area of this forum that discusses PM or are the topics scattered throughout the site.

I am finding the use of PM relatively easy at present but I'm not doing anything particularly complicated, but I am finding a few hurdles compared to EP such as renaming an item within a dimension, in EP it was easy, just click on the item and rename, but in PM it looks like you can only delete the item and recreate.

Feedback would be much appreciated

Admin Note: Moved to the correct forum. Any PM discussions are OK here.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: TM1 10.2.2 Performance Modeler Cloud

Post by David Usherwood »

I believe that the long standing members of the forum are used to Architect and Perspectives and were not impressed by Modeler. It has got better, and more solid, with later releases, but there remain many issues. Of course, people who come from the EP stream find it much more usable, since it has been written by the EP developers to make TM1 palatable to the EP community. TM1ers tend to take the view that it puts a layer between the developer and the engine which gets in the way. I've seen more vivid paraphrasing....
But please post questions. IBM say PM is the future direction so knowledge should improve. (It needs to)
andyhofer
Posts: 3
Joined: Sun May 03, 2015 5:44 pm
OLAP Product: 10.2.2
Version: 10.2.2
Excel Version: Excel 2010 2013

Re: TM1 10.2.2 Performance Modeler Cloud

Post by andyhofer »

Hi David, yes, I also heard that PM was the future direction. Cognos EP was never the most stable, issue free piece of software, and to be honest PM, at present, seems a more stable product, but as with all things, I'm still struggling as to how to achieve specific outputs.

So my first question :

Can you rename dimensional items, or must you delete then re add? From my brief understanding, deleting and adding will delete the data for that item, whereas renaming would leave the data in place.
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1 10.2.2 Performance Modeler Cloud

Post by declanr »

By "renaming an item within a dimension" do you mean renaming elements?

If so; it is a bit messy but the standard approach is to add a dummy alias; populate the alias with your new names for any elements you need to change; just leave it empty for the ones you want to stay the same and then use a single line in a TI Process that uses the SwapAliasWithPrincipalName() function:

Code: Select all

SwapAliasWithPrincipalName(<Dimension_Name>,<Alias_Name>,0);
You can delete the dummy alias afterwards.
Declan Rodger
andyhofer
Posts: 3
Joined: Sun May 03, 2015 5:44 pm
OLAP Product: 10.2.2
Version: 10.2.2
Excel Version: Excel 2010 2013

Re: TM1 10.2.2 Performance Modeler Cloud

Post by andyhofer »

OK, thanks for that. When I say "item" I mean it in the context of Cognos EP. The dimensions in EP are called DLists and the individual elements of the DLIst are called items. In Cognos EP you just click on the name and rename it, a little like you would do in File Manager in Windows. In PM there appears to be no rename, and deleting and recreating seems a backward step as it long winded and deletes the data.

I understand creating the new line first, then transferring the data, then deleting the old one would work, just seems a little awkward.

Thanks for the feedback.
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1 10.2.2 Performance Modeler Cloud

Post by declanr »

andyhofer wrote:OK, thanks for that. When I say "item" I mean it in the context of Cognos EP. The dimensions in EP are called DLists and the individual elements of the DLIst are called items. In Cognos EP you just click on the name and rename it, a little like you would do in File Manager in Windows. In PM there appears to be no rename, and deleting and recreating seems a backward step as it long winded and deletes the data.

I understand creating the new line first, then transferring the data, then deleting the old one would work, just seems a little awkward.

Thanks for the feedback.
Assigning an alias isn't really creating a new line and no transfer of data is required; an alias is just (as implied by the phrase) another name for the same element (item); the process just allows you to state which one will then be recognised as the principal name of that element - you don't really need to run the process at all... you could just have your elements with as many names as you want.
Declan Rodger
Post Reply