Dynamic filter with dimension property members

[Former Member]

Hello,

Is it possible to create a dynamic filter in the input template with dimension property members. By default the input template should show all dimension members (no filter required), if user select any property member it will show only selected property member values in the input template.

Thanks,

Kumar

[former_member186338 · Accepted solution]

Easy:

Select required property in A1 (or select "ALL") and refresh report.

P.S. Forgot to provide formula in A12:

=EPMDimensionOverride("000";"ACCOUNT";A2)

[Former Member]

Hi Vadim,

Your solution is working as required, but I am getting parenth also in the report, is it possible to show only base members in the input template.

Thanks,

Kumar

[former_member186338]

It was not specified in the initial question text, but absolutely easy:

=EPMDimensionOverride("000";"ACCOUNT";A2&" AND CALC=N")

instead of:

=EPMDimensionOverride("000";"ACCOUNT";A2)