IBM Support

Labels of repeated nested rows in TM1

Fix Readme


Labels of repeated nested rows in IBM Cognos TM1 are left blank. In Microsoft Excel the text font for the repeated label is made to match the background color, and therefor cannot be seen. In TM1 Web, the repeated cells are merged.


To see the hidden text in Excel you can change the color of the font by using a conditional format on the outer rows to override the default setting. This formatting on merged headers was previously not allowed in TM1 Web.

In TM1 10.2.2 FP1 and later releases, this method to override hidden text will work both in Excel and in TM1 Web websheets:
  1. Select: Conditional formatting > New rule.
  2. Select: Use a formula to to determine which cells to format.
  3. In the box Format values where this formula is true, type: =1=1
  4. Click Format and select how you want the hidden text to be viewed.
Note 1:
To obtain the correct area to format, click the up-arrow after the rule formula box and wipe the cursor over the cells in the required column. Select the cells from the Formatting Range in the top section of the worksheet, not the actual displated values. For example, you would wipe the cursor over all Element Name cells in that area.
Adding the rule:
image 1634
Note 2: 
After clicking the Format button on the Rule, choose Font and then a colour. Choosing the same black will 'unhide' these once once published to tm1web. If you choose another colour it will highlight all rule-processed cells once you publish - this can be useful for troubleshooting the websheet.
Selecting the Conditional Formatting area (Font colour)
image 1633
This has been tested at with PAfE 2.0.45 with PA 2.0.8 tm1web with the sequence: Create Exploration > Convert to Dynamic report > Add the Formula > Recreate Book > Publish.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"All Editions"}]

Document Information

Modified date:
02 October 2019