SAP Knowledge Base Article - Public

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


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.


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



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 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



hierarchy, AO, node, leaf, 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


SAP Analysis for Microsoft Office all versions