/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
There is a hierarchy displayed in an SAP Analysis for Microsoft Office report. The hierarchy is filtered and the user wants to deactivate the hierarchy by selecting the option "Flat Presentation".
The hierarchy is deactivated but the filter is lost. All members are displayed.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental".
Environment
- SAP Analysis for Microsoft Office
- SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud
Cause
This is the intended behavior. Selecting Flat Presentation displays all members of the dimension, which removes any active hierarchy filter.
Resolution
In order to deactivate the hierarchy and keep the filter in the dimension, it is necessary to use the option "Only Use Hierarchy <XYZ> for Filter" as shown below:
Keywords
lost, lose, removed, hierarchies, filtering, filtered, missing, selected , KBA , BI-RA-AO-XLA , Excel Addin , Problem
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)