Symptom
You want to remove a leaf or a node from a hierarchy using Filter by Member in Analysis for Office. After removing the desired node (leaf) its parent node(s) is also removed from the crosstab.
The same scenario occurs if the query is executed directly in RSRT transaction and the same steps are followed there.
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
1. All hierarchy nodes are selected
2. Remove a child node (Monitors 1) from the result set
3. Notice that all parent nodes (All Products and Monitors) of the node Monitors 1 are no more displayed in the result set
Cause
The display of a node in the result set requires the display of all children. Logically, a node cannot be displayed if it is no longer contained in the selection. The same behaviour can be observed in all tools based on OLAP layer, including transaction RSRT (or RSRT2) and BEx Analyzer.
Resolution
If you want to keep the disappearing parent node(s) in the result set, then you need to remove the desired node or leaf on the query definition in BEx Query Designer as follows:
1. Use exclusion filtering in Characteristic Restrictions for Monitors 1
2. Parent nodes All Products and Monitors are displayed
Keywords
hierarchy, AO, node, leaf, leaves, filter by member, parent, hierarchies, filter, children, child, disappear, removed, deselect, uncheck, unchecking, exclude, excluding, resultset , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-OT-OLAP , Analyzing Data , Problem