Monday 2 February 2015

Ignore vs Never ( ~ vs ^ ) consolidation properties

Lets see difference with ignore & never consolidation properties.



Ignore & Never (~ & ^) difference.
Ignore – when you set consolidation property for any member with ignore(~) then it mean that member will not participate or contribute value in it to the parent member in aggregation/rollup.
Never – When you set consolidation property for any member with Never (^)  then it mean that member will not participate or contribute value in it to its parent in aggregation and also it will not get aggregated across different dimension. Let me take you through with an example.
Ignore example










B1
B2
B3
B
     A1
10
30
50
60
     A2
20
40
60
80
 A
30
70
110
140

In the above example you can see I have set B2 member under dimension B as ignore and parents as Dynamic Calc. With ignore being set as consolidation property for B2 , you can see the difference in the aggregation. If you look at values at B for A1,A2,A member you will find the difference that B2 is ignored in aggregation. For example A1-->B = 10 + 30 + 50 = 90 in normal scenario when all members are set with (+) consolidation property which is default. Now as B2 is set to Ignore it is not considered in aggregation result at B. But member B2 gets aggregated across other dimension which mean, you can see B2-->A1 =30 ,B2-->A2=40 is getting aggregated across other dimension A, B2-->A = B2-->A1 + B2-->A2 [30+40=70].
Now when you set B2 as never then as said, it not only aggregates to its parent but also doesn’t aggregated across other dimension which is dimension A in our case.
Never example







 



B1
B2
B3
B
     A1
10
30
50
60
     A2
20
40
60
80
A
30
#Missing
110
140


You can see B2 is not getting aggregated across A as it was set to Never consolidate. (B2-->A1 + B2-->A2 = B2-->A  is not happening if you observe above compared to earlier example.)

 

7 comments:

Workflow in Hyperion Planning

Hyperion Planning Workflow Management Workflow in general mean process flow or data flow or serious of actions. This in hyperion ...