You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Map multiple members from one cube to another that do not have the same dimension

in Planning 15 comments

Summary:

Map multiple members from one cube to another that do not have the same dimension.

For example, we have two cubes, OEP_FS and Plan.

OEP_FS has a standard dimension along with one custom dimension, which is not present in the plan cube.


I have to push data from OEP_FS to Plan, which has a custom dimension that has a few members that are in the account dimension.


Account in OEP_FS: A_ABC (Parent)

A_123

A_345

Custom dimension in Plan: C_A_ABC (Parent)

C_A_123

C_A_345


I tried using data maps, but I was able to map only one member and not many members since the dimension was under the unmapped dimension list in the target section.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!