Currency Rollup - TM1 Rule Help
Posted: Sun Nov 02, 2014 6:14 am
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
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