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

Report with FCC - Getting parent entity's currency label

Hi. Have a report within Narrative connecting to FCC. Using MemberProperty("Entity", "Base Currency") to get the entity's currency label and show on the report. That works fine when the report is showing local currency (Currency dimension member = Entity Currency). When the user switches this member to Parent Currency, the report needs to show the parent entity's currency accordingly. I tried embedding the AncestorName function (which works on its own) within MemberProperty but that was rejected.

Thoughts?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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