Forum Stats

  • 3,837,007 Users
  • 2,262,219 Discussions
  • 7,900,179 Comments

Discussions

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

GrayMagellan
GrayMagellan Member Posts: 34 Blue Ribbon
edited Mar 4, 2014 9:42AM in Financial Data Management

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

Tagged:
GrayMagellan

Best Answer

Answers

  • GrayMagellan
    GrayMagellan Member Posts: 34 Blue Ribbon

    New information!

    FDQM recognize these rows in the import file as the Line Item Detail and successfully load them in HFM:

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

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

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

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

    But FDQM automatically appends to my "Line Item Detail Label X" Account and Entity names, so the export file looks like as this example:

    !Data

    !LINE_ITEM_DETAIL

    ACTUALQ;2012;Quarter4;YTD;1053;<Entity Currency>;PL_OE_OTH_OTH;[ICP NONE];[NONE];EP_OTH;[NONE];[NONE];"PL_OE_OTH_OTH-1053-LINE ITEM DETAIL LABEL1 2";2

    ACTUALQ;2012;Quarter4;YTD;1053;<Entity Currency>;PL_OE_OTH_OTH;[ICP NONE];[NONE];EP_OTH;[NONE];[NONE];"PL_OE_OTH_OTH-1053-LINE ITEM DETAIL LABEL1 5";2000

    ACTUALQ;2012;Quarter4;YTD;1053;<Entity Currency>;PL_OE_OTH_OTH;[ICP NONE];[NONE];EP_OTH;[NONE];[NONE];"PL_OE_OTH_OTH-1053-LINE ITEM DETAIL LABEL1 4";200

    ACTUALQ;2013;Quarter4;YTD;1053;<Entity Currency>;PL_OE_OTH_OTH;[ICP NONE];[NONE];EP_OTH;[NONE];[NONE];"PL_OE_OTH_OTH-1053-LINE ITEM DETAIL LABEL1 3";20

    !DATA

    The question is how to remove the automatically generated prefix in the Line Item Detail labels? Or even prohibit their automatic generation?

  • Francisco Amores
    Francisco Amores Member Posts: 1,694 Bronze Crown

    Hi

    you would like to take a look to EXPORT action script which manages line item details generation.

    Script HFM_EXPORT.vbs is locates in the FinancialDataQuality/bin folder

    hope that helps

  • GrayMagellan
    GrayMagellan Member Posts: 34 Blue Ribbon

    For which version FDQM did you point this file? I searched everywhere in Oracle\Middleware and did not find anything. I have FDQM 11.1.2.1 version.

  • Francisco Amores
    Francisco Amores Member Posts: 1,694 Bronze Crown
    Answer ✓

    SSorry I thought you were talking about FDMEE. For classic FDM you have to open EXPORT action script in Workbench Client. There you can see how lines are generated

    GrayMagellan
This discussion has been closed.