Page 1 of 1

Currency Rollup - TM1 Rule Help

Posted: Sun Nov 02, 2014 6:14 am
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

Re: Currency Rollup - TM1 Rule Help

Posted: Sun Nov 02, 2014 3:59 pm
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.