Button to change "Member Filtering by Property" (BPC10.0 / EPM)

[Former Member]

In BPC 10.0, I have an Excel EPM Report. On the Account dimension I use the "Member Filtering by Property" functionality. I do this to filter on a user defined property that indicate if GL Accounts are relevant for Budget. I need to add a button to the Excel Report for the users that will toggle this filter ON and OFF.

[Former Member · Accepted solution]

What you have described is the modification of the selected members in the report, using the EPMDimensionOverride API is the best method for dynamically changing the selected members from a dimension without doing it via the editor, and a VB macro could be written and assigned to a button to toggle between these two overrides:

assuming "000" is the default report being overridden, and TTL_GL is the parent node in the ACCOUNT dimension.

Override with property filtering:

=EPMDimensionOverride("000","ACCOUNT","ALL(TTL_GL) AND PROPERTY=Y")

and  without filtering:

=EPMDimensionOverride("000","ACCOUNT","ALL(TTL_GL)")

[Former Member]

Hi Kobus,

Did we work together on the AEL project?

anyways, Ryan's suggestion will work, just remember to to add a refresh function in the button as well.

Andy