FDM Datafile in differet format

764485

Hi

I created a FDM application to load data in to HFM application from a flat file.
After Import and validation steps are successful, it creates the data file in different format, which was not accepted by the HFM. Below is the sample of Data file created by FDM. Could someone please help me to find out what went wrong in the FDM Application?

+!InterCompany Detail+
+!Scenario=ACTUAL+
+!Year=2006+
+!Period=Jan+
+!Column_Order = Entity;Partner;Account;C1;C2;C3;C4;TransID;SubID;RefID;Date;TransCurr;Rate;Comment1;EntCurrAmt;TransAmt+
+USWFX;[ICP NONE];6500004;CLOSINGBAL_INPUT;BS_INPUT;OUTSOURCING;LOCALGAAPINPUT;;;;12/31/2000;;1;;-14692580;-14692580+

Regards

Varun Kaushal

Are you trying to load IC Transactions into HFM or Trial Balance data?? Because the adapter that you have configured is IC adapter which is used for loading IC Transactions into the transaction module of HFM.

Varun

TonyScalese

You're using the wrong HFM adaptor. This is the output produced by the Intercompany transaction adaptor. Change to the basic HFM adaptor.

Varun Kaushal

Are you trying to load IC Transactions into HFM or Trial Balance data?? Because the adapter that you have configured is IC adapter which is used for loading IC Transactions into the transaction module of HFM.

Varun

764485

Tony/Varun,

Yes, you are correct. I was using the IC Adapter and not it is changed to the correct HFM Adapter and it creates the data file in correct format.
Thanks for your help.