Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM - 'Replace' option with HFM loads.

845830May 16 2011 — edited May 17 2011
Hello Gurus,
I am using the 'replace' option when loading data to HFM from FDM. After reading many other related posts I underatand the replace option will clear the entity subcube in HFM for those entities in the new dataload. Many times in the GL, reclass entires are made to move data from one entity to another. This will result in an entity that existed in load #1 not being present in load#2. Based on what I understand, the entity that existed in load #1 will remain in HFM as there was nothing to force the clear during the replace. Is this true? If it is true, then how has FDM been replacing / clearing data all these years?

What recommedations are there to make sure HFM truly contains only the new dataload records and not any 'leftovers' from a previous load. According to our HFM consultants a clear data command for a single period that hours and hours and it not a viable option.

Your recommedations and comments are much appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2011
Added on May 16 2011
3 comments
1,037 views