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.