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.
Environment
- SAP BusinessObjects Analysis, edition for Microsoft Office
-
SAP BusinessObjects EPM solutions, add-in for Microsoft Office
Reproducing the Issue
- EPM - Report Editor > Filtering tab > Based one > "..." button > Dimension A > Select Member > A1 (context)
- Change the context member of dimension to A2 from A1 in the report.
- 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