Question & Answer
Question
How is data formatting applied in TM1 - Planning Analytics?
What are the priority rules?
Answer
Here are the points to remember when applying formats to data in TM1:
1- Only numeric data can be formatted (elements of type "Simple" or "Consolidated". Note: dates are numeric values too). Elements of type "String" cannot be formatted.
2-Dimension format takes precedence over cube format. The dimension format that is applied first is that of the last dimension having a format. However, in a view, if a dimension is placed as column, then its format takes precedence over all other dimensions, regardless of the position of that dimension in the structure of the cube.
3-If there is no dimension format, then the cube format is applied
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzIzAAK","label":"Planning Analytics-\u003EPlanning Analytics Workspace"},{"code":"a8m3p000000PC9LAAW","label":"Planning Analytics-\u003EServer Data Tier"},{"code":"a8m3p000000PC7XAAW","label":"Planning Analytics-\u003EWeb PASS Contributor Application"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
28 December 2022
UID
ibm16851957