Forum Stats

  • 3,853,838 Users
  • 2,264,283 Discussions
  • 7,905,465 Comments

Discussions

Period mapping in FDMEE

3047423
3047423 Member Posts: 151
edited Aug 31, 2019 12:57PM in Financial Data Management

Hi Team,

Can you please help me on below query,

Getting below source data file with period and year. Here source file period column format is different then target essbase cube period column format. how can this custom period to be defined?

pastedImage_0.png

thanks

Venkat

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Aug 25, 2019 6:46AM Answer ✓

    One way of achieving this if you want to read the period from the source file is to add an explicit source mapping like:

    pastedImage_1.png

    The period key can be mapped to your global or application mapping.

    pastedImage_2.png

    In your import format add the period as a source period row.

    pastedImage_3.png

    Then in your load rule, set the mapping to explicit and select the calendar.

    pastedImage_5.png

    If you didn't want to read the period from the source file then you can use default period mappings which will be driven from the POV.

    Cheers

    John

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Aug 25, 2019 6:46AM Answer ✓

    One way of achieving this if you want to read the period from the source file is to add an explicit source mapping like:

    pastedImage_1.png

    The period key can be mapped to your global or application mapping.

    pastedImage_2.png

    In your import format add the period as a source period row.

    pastedImage_3.png

    Then in your load rule, set the mapping to explicit and select the calendar.

    pastedImage_5.png

    If you didn't want to read the period from the source file then you can use default period mappings which will be driven from the POV.

    Cheers

    John

  • 3047423
    3047423 Member Posts: 151
    edited Aug 31, 2019 11:34AM

    thanks John for the detailed explanation...

    i again stuck at loading data from rev cube to finance cube as period dimension members format is different as below,

    pastedImage_0.png

    thanks

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Aug 31, 2019 12:57PM

    In my example just change the Year Target from "No Year" to the correct year for the period key.