This discussion is archived
2 Replies Latest reply: Nov 14, 2012 6:02 AM by Sarilla RSS

How to load the Calculated Data in HFM

Sarilla Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi Srikanth

    Thanks for your clear explanation.

    regards
    Sarilla

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points