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!

How do I organize the import text file for load line item detail in HFM through FDM?

GrayMagellanMar 3 2014 — edited Mar 4 2014

At this moment, it is a *.csv file in this format:

Year; Period; View; Scenario; Entity; ICP; Account; Custom1; Custom2; Custom3; Custom4; Amount; Value; LineItemDetails; Description

For example, now I have such the file content:

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_GRE;[None];RP_005;[None];[NONE];71,0000;<EntityCurrency>;Line Item Detail Label 1

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];EP_OTH;[None];[NONE];120,0000;<EntityCurrency>;Line Item Detail Label 2

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];EP_OTH;[None];[NONE];120,0000;<EntityCurrency>;Line Item Detail Label 3

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];EP_OTH;[None];[NONE];120,0000;<EntityCurrency>;Line Item Detail Label 4

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];EP_OTH;[None];[NONE];120,0000;<EntityCurrency>;Line Item Detail Label 5

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];RP_005;[None];[NONE];69,0000;<EntityCurrency>;Line Item Detail Label 6

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];RP_999;[None];[NONE];80,0000;<EntityCurrency>;Line Item Detail Label 7

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];RP_999;[None];[NONE];90,0000;<EntityCurrency>;Line Item Detail Label 8

2012;Quarter4;YTD;;1053;[ICP None];PL_OE_OTH_OTH;[None];RP_999;[None];[NONE];100,0000;<EntityCurrency>;Line Item Detail Label 9

2012;Quarter4;YTD;;1053;1009;PL_OE_OTH_OTH;[NONE];[None];[None];[NONE];33,0000;<EntityCurrency>;Line Item Detail Label 10

But FDQM does not import Line Item Detail in self

This post has been answered by Francisco Amores on Mar 4 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2014

Added on Mar 3 2014

#business-intelligence-applications, #financial-data-management, #import, #item, #performance-management-applications, #to

4 comments

436 views