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
Currency Rollup - TM1 Rule Help
-
- 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
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.
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
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