TM1Web Cell Formatting Error

Post Reply
pm3990
Posts: 1
Joined: Wed Jul 21, 2010 2:09 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

TM1Web Cell Formatting Error

Post by pm3990 »

I am having a problem with the element formatting in TM1 Web, using TM1 9.4.1 FP2. The example below demonstrates my problem.

Cube A has 3 dimensions, 2 of which have formats set on their elements.

Dim1: {Elem:Item, Format:None}

Dim2: {Elem:Value, Format:None; Elem:Percentage, Format:Percent}

Dim3: {Elem:Cost, Format:Currency; Elem:Count, Format:comma}

I created a view in the cube viewer where Dim 1 is a row, and Dim3 then Dim2 are cols. Based on the TM1 order of precedence for formats, it first uses the format for cols, bottom-most upward. It looks like the following, with the percentage formatting superceding all other formats:

Cost Cost Count Count
Value Percentage Value Percentage
Item1 $150.00 50% 12.00 75%
Item2 $200.00 25% 6.00 20%

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.
Cost Cost Count Count
Value Percentage Value Percentage
Item1 $150.00 $0.50 12.00 0.75
Item2 $200.00 $0.25 6.00 0.20

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 22, describes as the order of precedence.
Post Reply