Hi,
I am having an issue with my formats on TM1 Web and Excel. The formats are showing correctly in Architect.
The example below demonstrates my problem.
Cube A has 2 dimensions, 2 of which have formats set on their elements.
Dim1: {Elem:Value, Format:None; Elem:Percentage, Format:Percent}
Dim2: {Elem:Cost, Format:Currency; Elem:Count, Format:comma}
I created a view in the Architect where Dim 2 is a row, and Dim1 is cols. Based on the TM1 order of precedence for formats, it first uses the format for cols. Which is what is displayed in Architect however when I view this in TM1 Web the formatting of Dim 2 is what is shown.
When I view this in TM1 web, the format does not come out the same. The percentage format which should supercede all other formats does not get applied. Only the formatting for Cost and Count get applied.
Regardless of the order of the dimensions, it appears that the format for the last dimension in the *cube* list takes presendence when presented in TM1 Web. This is in contrast to how the Architect Cube Viewer displays it and what the TM1 Developer Guide, pg 24, describes as the order of precedence.
Is someone able to help with this issue and if there is a way around it?
Paid Advertisement:
