Traffic Lights in an Excel based TM1 report are dead simple. Here is a fully worked exercise to follow to create them and a series of ideas for their use.
Display TM1 Attributes in Cognos Analytics Crosstab
Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the rows, rather than the element IDs from TM1.
Rounding in TM1 – The Complete Guide!
ROUND and ROUNDP are often confused and users expect them to behave the same as the Excel function. They are very similar but are different to the Excel treatment. Here is a complete explanation of both functions, a comparison to Excel ROUND and screenshots of the usage of both functions.
SUBNM Excel TM1 Function: Syntax, Use and Example
SUBNM allows you to use a subset from a TM1 dimension for drop-down selection in an Excel report or form and open the subset editor to select elements.
How to Dynamically Assign Data based on Selection in a Planning Model
How to create a planning model where users can enter and select variables in one location and TM1 then assigns the data dynamically to all required dimensions.
Selective Clear Cube based on Variable Source Data
Detailed instructions on how to clear a variable selection of data that is going to be reloaded from the source. Includes sample TI code and explanations.
StringToNumber TM1 Process: Use and Syntax
StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.
DimensionElementPrincipalName, Syntax and Use
DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.
URL to Log an IBM Cognos or IBM TM1 Support Call
Here is a quick link to the IBM support website. From it you can log Cognos Support tickets and create TM1 Support Requests, directly with IBM.