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.)
