3 Replies Latest reply on Oct 10, 2012 7:59 AM by 957528

    What is the Difference between Consolidation and Aggregation

    kodalitaruni
      Hi Masters


      What is the difference between Consolidation and Aggregation? i think both are same, what is the exact difference in-terms of HFM and Essbase?

      regards
      Taruni
        • 1. Re: What is the Difference between Consolidation and Aggregation
          CBarbieri
          The differences lies in the mechanism used to calculate and store the value. Dynamic members such as parent accounts or customs, derived views, parent periods, or <Total> members in the value dimension are performed on the fly in the HFM app server's memory without any discrete action on the user or adminisrator's part. These are aggregations in this context, and are distinct from amounts that are calculated and then stored in the HFM database which are either the result of direct data entry (from data loads or journals) or calculated amounts resulting from HFM's rules. "Consolidation" in your question would be one of the stored, calculated amounts in HFM.

          --Chris                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
          1 person found this helpful
          • 2. Re: What is the Difference between Consolidation and Aggregation
            kodalitaruni
            Hi CBarbieri

            Thanks for your inputs.

            regards
            Taruni
            • 3. Re: What is the Difference between Consolidation and Aggregation
              957528
              Aggregation would just add up all the values in the child members and show the sum in the Parent.

              Consolidation would add up the values from child members and at the same time, it will eliminate InterCompany transactions and other values that need to be eliminated, and then roll up the values to the parent.

              Planning and Essbase are good at Aggregation, while HFM does translations. That's what these tools are built to do.