Map multiple members from one cube to another that do not have the same dimension
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.