Fix Readme
Abstract
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.
Content
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:
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.
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:
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)
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":"BU053","label":"Cloud & Data Platform"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
Cognos TM1
Software version:
10.2.2
Operating system(s):
Windows
Document number:
532393
Modified date:
02 October 2019
UID
swg21962268
Manage My Notification Subscriptions