2 Replies Latest reply: Nov 14, 2012 8:02 AM by Sarilla RSS

    How to load the Calculated Data in HFM

    Sarilla
      Hi Gurus

      1.How to load the Calculated Data in HFM?

      I have extracted Calculated data and when i tried to load the calculated data in HFM it is partially loaded, showing errors as you can not load data for parent members of Account,Custom 1-custom 4......
      Then i have ran the consolidation to get the parent values.
      Is there any alternative way to load the calculated data in HFM?

      Regards
      Sarilla
        • 1. Re: How to load the Calculated Data in HFM
          878634
          Hi Sarilla,

          Calculated Data cannot be loaded into HFM manually, the data for these accounts with calculated field should be generated through the calculation logic's.

          And Parent Members also don't get loaded the data as they are the parents for sum of some base level accounts.

          So just load the data for the base level accounts and make sure they are consolidated field accounts, than there would be no error and for the calculated accounts the data automatically generates through the logic written in Rules file.

          And after loading the data just run the consolidation and also sink the rule file in both the instances to work out the calculation logic's.

          Regards,
          Srikanth
          • 2. Re: How to load the Calculated Data in HFM
            Sarilla
            Hi Srikanth

            Thanks for your clear explanation.

            regards
            Sarilla