Renaming Elements in Cognos TM1 Dimension

Reanming Elements in a Dimension:

We can rename an element in a TM1 dimension by using a function called SwapAliasWithPrincipalName

Steps:

1. Create a new alias "new" in the Dimension, by default the new elements are identical
2. Change all required elements to their new names in the "new" created alias
3. Create a new TI process with the following line in the Prolog:
• SwapAliasWithPrincipalName(Dimension,'new',0);
4. The third parameter needs to be zero to execute the swap. If it has any other purpose, please edit/leave a comment

Backing out changes in Cognos TM1

Backing out Changes (Where Possible)
Under specific circumstances data changes made to a cube can be ‘Backed out’ via the TM1 Transaction Log. In order for this to be possible the cube must have logging enabled (“}cube_properties” control cube).

Steps to back out data changes:

1. Right Click on the Server within “Server Explorer”
2. Select “View Transaction Log”

3. Select the Date you wish to search from
4. Select the Cube and/or User (who’s actions you wish to reverse)
5. Execute the Search
6. Highlight the items you wish to “back out”
7. Under “View” click “Select” and click "Back out"

Creating a cube through TI process with new dimensions

Please follow the below steps to create a new cube through TI process with new dimensions:

1. Select process and then select ‘Process\Create New Process’ as shown in the below screenshot

2. Now Turbo Integrator window will be opened
3. If your source is an external database (For Ex: SQL SERVER), click on ‘ODBC’ as your datasource type under ‘Data Source’ tab inside the TI process.
4. Click on Browse and select the ‘Data Source Name’ (which should be created before selecting the datasource name, create a DSN for the database which you are going to use).
5. Write the query to fetch the data from the database inside ‘Query’ and click on ‘Preview’ button. If everything works fine, you can see the top 10 records under preview section.
Note: If you feel that all the columns are there under preview section, then no need to do anything. If not, please modify your query to get your columns.
6. Click on Variables tab and now you can see all the columns which you previewed in the previous tab.
7. Change the contents for all the variables (Ex: Element, Consolidation, Ignore, Other etc)
8. Click on ‘Maps’ tab and click on ‘Cube’ tab.
9. Click on ‘Create Cube’ under ‘Cube Action’ and provide a cube name.
10. Click on ‘Accumulate/Store’ values based upon your requirement under ‘Data Action’ for storing the data inside the cube.
• Accumulate: Aggregates the values with existing data
• Store: replaces the data
11. Click on ‘Dimensions’ tab and provide the new dimension name under ‘Dimension’ and also specify the order of the dimension in the cube. If you are creating new dimensions, please double check whether the ‘Action’ contains ‘Create’.
12. Specify the element type for the dimension.
13. Click on ‘Consolidation’ tab and assign the N level elements to the consolidation element to create a hierarchy.
14. Click on ‘Advanced’ Tab and then click on ‘Prolog’, ‘Meta Data’, ‘Data’ and “Epilog’. The TI process will automatically writes the script inside the relevant tabs.
15. Save the process with a name and then execute it to create a new dimension.