Differences between Ignore (~) vs Never(^) consolidation properties

Let us discuss about what are the differences between ignore and never consolidation.

     Ignore consolidation:

          When you set any member in the Database outline as Ignore(~), that means Essbase does not consider that member value into its parent level in aggregation/rollup.

       Let us discuss with an example:

         From the above figures, we came to notice that, under Account dimension, I had given "No account" as child with a consolidation property as "ignore". Now you can see the difference in aggregation. From the aggregated result you can see that, value of "No account" is aggregated to "Period" dimension but not to "Account" dimension (i.e.., No Account -> period =100+200=300 and No Account -> Account =300 only). Because we set "No Account" is considered as ignore.So that we can say that, if a member is tagged as ignore, it will not be aggregated in its dimension but aggregates to other dimension.

Never Consolidation:

       When you set any member in the Database outline as Never(^), that means Essbase does not consider that member value into its parent level in aggregation/rollup and also doesn't aggregates in other dimension.

      Let us discuss with an example:

         Here, you can notice that "jan" kept with never consolidate operator.So,the values under "jan" are not consolidated to "Period"(in its dimension) and also not to "Account" (different dimension).