ICP dimension conflict with HFM
798182Apr 6 2011 — edited Apr 8 2011Hi 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