Forum Stats

  • 3,853,831 Users
  • 2,264,280 Discussions
  • 7,905,460 Comments

Discussions

FDMEE Dimension Mapping

user11203834
user11203834 Member Posts: 155 Blue Ribbon
edited Sep 9, 2019 2:59AM in Financial Data Management

Hello,

I have requirement to push data from my PBCS Source environment to another PBCS Target Environment.

And at the source, i have 12 dimensions and at the target i have 7 dimensions as below.

4 Dimensions can directly map in the import format as it is directly linked exist in both source and target Environment.

I have 1 dimension in target and which does not exist in source, can anyone tell me how i map this dimension in import format as i do not have the corresponding source dimension.

Any help highly appreciated.

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Sep 9, 2019 2:59AM Answer ✓

    You shouldn't need to map it in the import format. You can just add a like data load mapping to map to a target member.

    An example with a planning to planning app

    pastedImage_0.png

    pastedImage_1.png

    pastedImage_2.png

    Alternatively you can map to any source column, add a constant expression, apply a data load mapping.

    pastedImage_0.png

    pastedImage_2.png

    Cheers

    John

Answers