PA TM1 Web difference on Scale Divisor

Post Reply
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

PA TM1 Web difference on Scale Divisor

Post by paulsimon »

Hi

On some reports users want the ability to see figures in Units, Thousands, Millions, etc.

We implemented this with a lookup and that gives a scale divisor of 1, 1000, 1,000,000 and then our DBRW formula were dividing by rScaleDivisor.

This worked fine in Active Forms in 10.1 TM1 Web.

However, it does not work reliably in PA TM1 Web. In some cases the report never finished running. Even worse, in other cases it appears to cause some lines to be randomly omitted from the reports.

The work around and arguably the better approach is to create consolidation measures above the unit level measure and use weights to divide by 1000 eg

Millions weight 0.001
Thousands weight 0.001
Units

Then the lookup from Units, Thousands, Millions, just needs to select the appropriate measure which is then referenced in the Active Form DBRWs.

Regards

Paul Simon
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: PA TM1 Web difference on Scale Divisor

Post by tomok »

If you don't care about the footings at the bottom (i.e., no rounding) then you can also do the same with conditional numeric formatting in your report. Have the conditional formatting change based on your selector drop-down. I've done the same thing a few times before and it works fine.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: PA TM1 Web difference on Scale Divisor

Post by Wim Gielis »

paulsimon wrote: Wed Feb 20, 2019 11:05 am
The work around and arguably the better approach is to create consolidation measures above the unit level measure and use weights to divide by 1000 eg

Then the lookup from Units, Thousands, Millions, just needs to select the appropriate measure which is then referenced in the Active Form DBRWs.
True. Because if I’m not mistaken TM1 treats =DBRW/1000 as DBR, isn’t it ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply