How to use a member category in a data integration mapping?
in Planning
Summary:
I'm building an integration between 2 cubes of PBCS.
In the mapping, I want to use the categories of the dimension members (instead of the dimension members).
Content (please ensure you mask any confidential information):
For our project dimension (custom dimension), in the mapping, I want to display the member value as the 'Source- Project'.
However, I want the category linked to that source member to be displayed as the target.
So for the project 'P00060010516', the mapping would display 'P0060010516' as source and 'Going concern' as target.
How can I achieve this?
Version (include the version you are using, if applicable):
Tagged:
0