Forum Stats

  • 3,759,024 Users
  • 2,251,493 Discussions
  • 7,870,471 Comments

Discussions

FDM Data Load format

649879
649879 Member Posts: 40
edited Oct 29, 2008 12:36PM in Financial Data Management
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
Tagged:

Answers

  • 631379
    631379 Member Posts: 660
    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.
This discussion has been closed.