CONSOLIDATION OPERATORS IN ESSBASE

                            

• Consolidation Operators defines how essbase rolls up data to each memmber in a branch to a parent.
• When you define a new child member of a dimension, you need to tag that member with a consolidation operator. A consolidation operator will tell Essbase how this member will be calculated along with its sibling member(s) upto the parent member.

                                   TYPES OF CONSOLIDATION OPERATORS

• Addition (+):adds this member to the result of the previously calculated sibling member calculation.
• Subtraction (-):subtracts the member by (-1) then adds the product to the result of the previously calculated member.
• Multiplication (*):multiplies this member by the result of the previously calculated member. 
• Division (/):divides the result of the previously calculated member by this member.
• Percent (%):divides the previously calculated member result by this member and multiples it by 100.
• Ignore consolidation (~):do not contribute its value to its parent member.
• Never consolidate (^):The member which is tagged as "^", will not participate in it's parent aggregation and across different dimension.

                                                  EXAMPLE:

                         EXAMPLE FOR OPERATOR "+"(ADDITION):

• In the above example,all the members of USA are tagged with "+".
• let us the result in below image:

• So all the members of usa are consolidated.

                                         EXAMPLE OF OPERATOR "-"(SUBTRACTION):

• In the above example,the members of  USA(MI,VA) are tagged with "-".
• In the below image we can see the result of the operator "-" i.e, when we connect to smart view:

• So members got subtracted.

EXAMPLE OF OPERATOR "/" (DIVISION):

• In the above example, member "VA" is tagged with "/" operator.

• In the above image we can see the result of operator "/".

      EXAMPLE FOR OPERATOR "~" (IGNORE CONSOLIDATE):

• In the above example, "VA" is tagged with "~".

• We got the result when we conected to smart view,as VA is tagged with "~" operator it does not consolidates to its parent.

                      EXAMPLE FOR OPERATOR "^"(NEVER CONSOLIDATE)

• In the above example,VA is tagged with "^".

• As "VA" is tagged with "^" it did not consolidate in both ways.

MAIN DIFFRENCE BETWEEN IGNORE CONSILDATE AND NEVER CONSOLIDATE:

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.