Cognos: Making Levels visible in TM1 Cubes in Report Studio

When building reports in Report Studio, you will find that dimensions within a TM1 cube do not render their levels by default, as a Cognos Powercube does.

Cognos Powercube – Levels

Cognos: Making Levels visible in TM1 Cubes in Report Studio | QMetrix

 

TM1 Cube – No Levels

Cognos: Making Levels visible in TM1 Cubes in Report Studio | QMetrix


Levels are required in dimensions for some functions within Report Studio (eg PeriodtoDate function).

To enable the rendering of levels in TM1 cubes, the following steps must be completed:

1. Turn on Display Control Objects

Cognos: Making Levels visible in TM1 Cubes in Report Studio | QMetrix

 

2. Select the Cube }HierarchyProperties

Cognos: Making Levels visible in TM1 Cubes in Report Studio | QMetrix

 

3. Drag the }Dimensions into rows of the cube viewer and select the dimension you wish to add levels to

4. Populate the name of each the levels in the dimension

Cognos: Making Levels visible in TM1 Cubes in Report Studio | QMetrix

 

5. Restart the TM1 service

You can now open the cube in report studio and the levels should now appear in the dimension.


Cognos: Making Levels visible in TM1 Cubes in Report Studio | QMetrix

 

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content