Mapping between 2 data sources
SummaryMapping between 2 data sources
Is there a way to map dimensions between 2 data sources? or map members in certain dimension between 2 data sources?
we are trying to generate a report containing grids from 2 data sources, currently we have slight differences in dimension names and members between the 2 data sources, is there a way to create some kind of mapping in Narrative Reporting for data sources so users can select members once instead of having them to select them twice?
Example 1: dimension year is called "Years" in FCCS and "Year" in PBCS
Example 2: in dimension currency, "Entity Currency" in FCCS is called "Local" in PBCS and "USD_Reporting" in FCCS and "USD" in PBCS