EPMDimensionOverride on rows

[Former Member]

Hi experts,

I have to do a report that depends of radio button show BASMember of selected member (first option) or show CHILDREN of selected member (second option) in rows.

How can I do with EPMDimensionOverride function? I would like that when user select radio button automatically change my report.

Thanks!

[former_member186338 · Accepted solution]

Hi Alex,

If you read help on 33.8.1 EPMDimensionOverride you will see that you have BAS and DEP for your requirements:

=EPMDimensionOverride("000","Somedim",B1&"("&B2&")")

Where B1 - BAS or DEP, B2 - selected member.

Vadim

[former_member186338 · Accepted solution]

Sample using traditional Excel radio buttons inside frame:

[Former Member · Accepted solution]

Thank you very much!

It works!