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.
TM1 10.2.2 Performance Modeler Cloud
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: TM1 10.2.2 Performance Modeler Cloud
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)
But please post questions. IBM say PM is the future direction so knowledge should improve. (It needs to)
-
- 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
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.
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.
-
- 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
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:
You can delete the dummy alias afterwards.
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);
Declan Rodger
-
- 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
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.
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.
-
- 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
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.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.
Declan Rodger