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
PA TM1 Web difference on Scale Divisor
-
- 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
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.
-
- MVP
- Posts: 3113
- 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
True. Because if I’m not mistaken TM1 treats =DBRW/1000 as DBR, isn’t it ?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.
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
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