Rule based ELISANCN type functionality

[garry cook]

I'm looking at rule driving an attribute to count how many times an element turns up in a consolidation within a deep heirarchy and struggling to come up with logic to do this. Normally I'd run this through a TI but I'd like to rule drive this in the attributes cube.

Any suggestions?

I'm thinking about putting through an enhancement request for ELISANCN unless I'm missing something obvious.

TIA

[Duncan P]

Which of these (if any) do you want to know?

1. In how many consolidations does each element occur?

2. For each leaf/consolidation pair how many times does the element count toward the consolidation?

3. What is the weighted contribution of each leaf in each consolidation, given that each parent/child relationship might have an associated weight?

If it is 2 or 3 then you will need to represent the results in a cube with the leaf elements on one dimension and the hierarchy itself on another.

If you want the contribution or if there are no non-default weights on the hierarchy just put in the rule

Code: Select all

[] = N: IF( !hierarchy @= !leaves, 1, 0 );

and count the values at the corresponding consolidated elements.

If your hierarchy has weights and you want the unweighted number of times each leaf contributes to each consolidated element then I'm afraid I can't help you.