I am trying the find out what is the best way to disable consolidation levels in a cube, meaning not to display any values in consolidation elements.
This might be the requirement for cubes holding Price or Unit Cost info, you may not want to display any aggregations in aggregate levels of product dimensions or time dimension.
I know that we can easily do it using the following rule statement:
Code: Select all
[]=C:0;
1 - Is there any other way of achieving this requirement?
2 - Is it more expensinve to have this rule than leaving it without any rule and let consolidations being calculated as default?
Obviously using a seperate product dimension that does not have C levels or zero weights is not considered as an option.
Thanks in advance for replies.
Regards,