What's the best practice in archiving HFM application.
Our current HFM applications has data for about 7 years and having lots of dormant accounts and entities.
The challange is, we cannot remove the dormant accounts and entities as there are historical data attached to it.
How can we archive the existing application, and keep only the last 18 months of data in the application
and removing the dormant accounts and entities?
The easiest way to do that is to build a new application and transfer only the data of the last 18 months. Based on the specific data, you can review the metadata and the rules and you will remove any dormant members.
< spam signature link removed by moderator >
I have done it before and it is quite good because you can have access to your previous data while introducing a new application.
There are different ways to treat opening balances. I have seen it done by manually imports and exports. However, I prefer to write rules in both apps to extract and load the data without any manual intervention. Of course, this means that you are not changing the metadata between the two apps.