Some members/dimension combination should not consolidate

[abcuser]

Hi,
using Cognos TM1 9.5.2 on Windows. I have a cube with some products in combination of organization unit that should NOT sum into total. I have created very simple cube to demonstrate a problem. Please see attachment.

Is there a way I can force TM1 to execute one dimension consolidation before another, for instance consolidate product dimension before organization unit?

Is there any other way I can solve this problem?

Please see attached sample bellow.
Regards

[jim wood]

The whole point of OLAP is it is multi dimensional object. There is no consolidation order. The only way around that I know of is the way you have done it, via rules.

[ioscat]

as i suppose parent does not aggregate simply its direct children, but all its leaf children. so order of accumulation is no matter.

[aking]

You may want to look at the Rule Function ConsolidateChildren
http://pic.dhe.ibm.com/infocenter/ctm1/ ... ldren.html

[abcuser]

@jim wood, what I have done in rules is just part of the solution. But TM1 has decided to consolidate test_unit dimension before test_product dimension which leads to result I don't like.

@ioscat, yes, I have read in manual of aggregating upper levels directly from leaf children. There is also an info of not having a real influence on consolidation order. I just thought someone has some trick...

@aking, I know about ConsolidateChildren function, but having really bad experience with it, big performance drop in production cube size. So I try to avoid ConsolidateChildren function as much as possible.


As I can think of the only really good solution is to add additional dimension to the cube and name it something like "product type" and then for each leaf dimension combination define the product type. In this case consolidation should work correctly... I just thought there is some other simple to implement solution without adding new dimension.