FDM Data Load format

649879

Hi All,

I am new to FDM. I have some clarifications in the FDM data load format.

Please let me know,
1) what is the difference in the below two formats ?
2) How to ignore the first 7 rows while loading into FDM (in format1) ?
3) Does the character '!' means comment - FDM will ignore that ?
4) Can we automate data load in FDM ?

Format1: (.txt format)
-----------------------------------------------
!SCENARIO=ACTUAL
!PERIOD=SEPTEMBER
!YEAR=2008
!VIEW=YTD
!VALUE=USD
!COLUMN_ORDER=ENTITY,ACCOUNT,ICP,CUSTOM1,CUSTOM2,CUSTOM3,CUSTOM4,AMOUNT
!DATA
US,1000,101,[none],[none],[none],[none],1000.00

Format2 (.txt format)
------------------------------------------------
Actual,September,2008,YTD,EUR,Europe,1001,110,[none],[none],[none],[none],5000.00

Thanks,
Siva

631379

Both formats will perform the same. Format 2 is the normal method for loading data. Format 1 is telling FDM to set those 5 dimensions to those values for all following records.

You cannot ignore the first 7 rows of Format 1 or the system will not know what you are loading. Actually, the system would default to Format 2 and read you data into those dimensions.

The ! means that the following line is for system reference only.

Yes. The system supports vb script and I believe there is a published API.