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!

FDM Data Load format

649879Oct 28 2008 — edited Oct 29 2008
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

Comments

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.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 26 2008
Added on Oct 28 2008
1 comment
1,171 views