2530007 - Parent node is not displayed if not all child nodes (leaves) are selected

After removing a leaf or a node from a hierarchy using Filter by Member in Analysis for Office 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.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

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

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.

If you want to still keep the disappearing parent node(s) in the result set, then you need to remove the desired node or leaf in the query definition using BW Modeling Tools or BEx Query Designer.

This behavior is documented in general in
KBA 2751443 - BW Hierarchy: Filtering (excluding) nodes from a hierarchy removes their parent nodes

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