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!

ICP dimension conflict with HFM

798182Apr 6 2011 — edited Apr 8 2011
Hi Guys,

I need your help for the following, I am using FDM 11.1.1.3 together with HFM 11.1.1.3.50. Now, in HFM the ICP dimension has been set up as follows (for which I have been told this is not best practice):

Parent: [ICP TOP]
Child1: [ICP NONE]
Child2: [ICP entities]
Children: 001 to 940

Apparently, FDM assumes that [ICP NONE] should be the parent. At least, I cannot export the ICP values for the entities like they should. Currently there is a workaround with logic accounts and a script in place:

-The script adds 'ICP.' in front of an account when it is carrying ICP.
-ICP mapping says export all to [ICP NONE] except when the account starts with L-
-Logic accounts have been created to duplicate each 'ICP.' account.
-The values of these L- logic accounts are then exported to the children of [ICP ENTITIES].

Needles to say this requires quite some maintenance since for each account that carries ICP values in a flat file, a new logic account needs to be created and mapped.

Any solution or suggestion how I can modify FDM and formulate the set up of the HFM ICP dimension? Or how I could minimize the maintenance? You would be of great help!

Kind Regards,
JDeM
This post has been answered by TonyScalese on Apr 6 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2011
Added on Apr 6 2011
27 comments
2,183 views