We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Mapping between 2 data sources

Received Response
10
Views
4
Comments
edited Oct 5, 2020 7:25AM in Narrative Reporting 4 comments

Summary

Mapping between 2 data sources

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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