Integrating TM1 9.5 and Cognos BI – Part 2

​Integrating TM1 9.5 and Cognos BI – Part 2

We continue from the previous Lodestar blog on Integrating TM1 9.5 and Cognos BI  withTM1 tips.

Integrating TM1 9.5 and Cognos BI

The }HierarchyProperties control cube in TM1 stores custom named levels for the hierarchy levels of TM1 dimensions. You can enter your own names for these levels in the }HierarchyProperties control cube and then use these names outside of TM1 to access TM1 data with IBM Cognos Report Studio, MDX statements or other MDX OLAP tools. You can also use this control cube to assign a default member for the dimension.

  1. In TM1 Architect, click the View menu and select Display Control Objects in the navigation pane, click to expand the Cubes
  2. Open the }HierarchyProperties control cube
  3. Click the title dimension list to select the dimension for which you want to assign named levels
  4. In the default Member cell, enter an existing element name to set as the default member for this dimension: Allows for filtering the dimension when TM1 data is retrieved from IBM Cognos Report Studio
  5. Enter your own custom name for each hierarchy level that exists in the dimension
  6. After configuring named levels, you must do one of the following to apply the changes: Restart the IBM Cognos TM1 server, or Run the RefreshMdxHierarchy function in a TurboIntegrator process.
Heads Up!
  1. Changes to element names or dimension structure are not automatically detected by the named levels feature.
  2. If your dimension changes, you must first manually update the named level assignments in the }HierarchyProperties control cube, then either restart the TM1 server or run the RefreshMdxHierarchy TurboIntegrator function to update the MDX hierarchies in the TM1 server.
  3. Watch out for names: if a TM1 cube has a level named "Products" and a member in the hierarchy also has the name "Products" when the cube is published, it will error.

In case you missed part 1 of our Lodestar TM1 tips, click HERE.

Leave a Comment

Send this to a friend