Calculate Averages with Hierarchies – Average from Children

By - Jul 14, 2014

Resolution

MDX Rule

3. Average by Non-empty Children

Explanation

We will define the aggregation at non-leaf level in the hierarchy in MDX rule, dividing aggregation value by the count number of non-empty children.

071414_1929_CalculateAv1.png

Steps

1. Create a MDX rule in Kepion.
2. Define the MDX rule as follow.

3. Deploy the application.

4. Average by All Children

Explanation

This calculation is very similar to the Average by Non-empty Children. The only difference is the divisor value should be the count of all children of the given member.


Steps

1. Create a MDX rule in Kepion.
2. Define the MDX rule as follow. Notice the difference in the highlighted area.

3. Deploy the application.

 


Facebooktwitterlinkedinmail