Consolidated Elements don't Consolidate

[Jose.Mong]

Dear Sirs, hi everybody...

Regarding to Consolidated Elements and Feeders Statements, I have only one issue... let me explain...

************ FIRST SCENARIO ************

This is my Rule (all elements are leaf levels): ['LeafLevel1', 'LeafLevel2', 'LeafLevel3'] = N:DB('CubeName', !DimensionA, !DimensionB, 'Element_N');

This is my Feeder (in another cube): ['Element_N'] => ['LeafLevel1', 'LeafLevel2', 'LeafLevel3'];

...the consolidated level ("Total") of "LeafLevel3", brings to me the correct amount without problem

************ SECOND SCENARIO ************

This is Another Rule (only a single element is Consolidated): ['LeafLevel1', 'ConsolidatedLevel', 'LeafLevel3'] = C:DB('CubeName', !DimensionA, !DimensionB, 'Element_N');

This is my Feeder (in another cube): "it don't need feeder statements"

...but, in this second scenario, the consolidated level ("Total") of "LeafLevel3", doesn't works, because this concolidated level shows: "0"

You can see the attachment Excel file for a better understanding..., then, my question is:

How can I fix this situation?, in the Second Scenario, without alter the rule, because when I change "C:" by "N:", then the rule doesn't work neither.

Regards,

[Duncan P]

For any consolidated value (provided that no calculation statement applies to it) the consolidation is done by adding the values of all leaf values under it.

Your consolidated value defined in the rule may be underneath the "Total" but it is not at leaf level and so it does not contribute to the value for "Total".