SAP Knowledge Base Article - Public

3428377 - EPM filtering does not reflect context selection

Symptom

If you create an EPM report and filter based on columns you will notice that your selection is locked to one member.

For example, if you have the category dimension in the columns and want to filter the value for that dimension you will notice that you are restricted to one member. If you select the "Context" the expectation is that this should be a dynamic selection updating the filter but that is not happening it just save the single member.

2024-02-02_12-39-38.png

Environment

  • SAP BusinessObjects Analysis, edition for Microsoft Office
  • SAP BusinessObjects EPM solutions, add-in for Microsoft Office

    Reproducing the Issue

    1. EPM - Report Editor > Filtering tab > Based one > "..." button > Dimension A > Select Member > A1 (context)
    2. Change the context member of dimension to A2 from A1 in the report.
    3. The filtering doesn't filter data based on A2 and the Filtering Criteria is fixed to A1.

    Cause

    This is by design behavior.

    When the filter is defined, it is based on the dimension member which is currently positioned in the context then the filter is saved with this dimension member.
    Indeed, that does not mean that you saved the filter for any dimension member positioned in the context, only for the dimension member currently in the context for this dimension.

    Resolution

    N/A

    Keywords

    EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver,Excel, EPM add-in, Filtering, context , KBA , EPM-XLS , EPM Excel Client , EPM-BPC-NW , NetWeaver Version , Problem

    Product

    SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8