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?
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.