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.
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:
- Select: Conditional formatting > New rule.
- Select: Use a formula to to determine which cells to format.
- In the box Format values where this formula is true, type: =1=1
- Click Format and select how you want the hidden text to be viewed.
02 October 2019