Currency Rollup - TM1 Rule Help

Post Reply
sh226
Posts: 30
Joined: Wed Jun 06, 2012 8:59 pm
OLAP Product: TM1
Version: TM1 9.5.2
Excel Version: 2010

Currency Rollup - TM1 Rule Help

Post by sh226 »

Hi all,
I have a view currency dimension that has Top level rollup called Reporting_A and under this rollup there are two n level elements Reporting_B and Reporting_C. There is a rule in a cube that is loading data at reporting_B and Reporting_C level which shows the consolidation of that data at Reporting_A level rollup which is in result doubling the values. I want to either suppress Reporting_B or Reporting_C so that top level rollup dont show a consolidation of two (Reporting_B and Reporting_C)? There is a standard time dimension that has year-quarter-month rollup as well. To explain it in simple here is what i want:

B=2
C=2
Top level rollup A with children B and C = 2

Thanks in advance for your help
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Currency Rollup - TM1 Rule Help

Post by Wim Gielis »

Hello

But you do need that consolidation in your cube, right?
If not, you just delete the consolidation or put one of the children weights to 0.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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