TM1 Forum

Dear All,

What's the best way / approach to report figures in 1000s; after they have been pulled into the Cubes from the source. Can we avoid writing rules and use any formattings features etc? Currently this is done in Excel, I would prefer doing it in TM1 itself.

Appreciate all your inputs.

Thanks

A) If you need only the 1000s value
Divide the data during the data load.
You can reprocess and divide the data with a process sheet or with TI easily.

B) If you need both the original and the 1000s values
From technical point of view the easiest way is to create a c element with one child and .001 weight.
The most importan advantage is that you do not need feeders for this calculation.

Thanks Peter. Appreciate the quick reply and cool idea.
Cheers!

You are welcome.

These are technical approaches and do not take any rounding issue into consideration.
It is important to discuss the rounding issues with the end users before you decide about your method.

Personally I use the custom format
#,##0,
for thousand scaling.
Many, but not all, Excel formats will work in TM1. Sometimes you need to frig them a bit. Can't recall if they are documented properly anywhere.