SAP Knowledge Base Article - Public

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

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

kba1.PNG

2. Remove a child node (Monitors 1) from the result set

kba2.PNG

3. Notice that all parent nodes (All Products and Monitors) of the node Monitors 1 are no more displayed in the result set

kba3.PNG

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

kba4.PNG

2. Parent nodes All Products and Monitors are displayed

kba5.PNG

Keywords

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

Product

SAP Analysis for Microsoft Office all versions