SAP Knowledge Base Article - Public

2459033 - New Lines - Planning Data - Cannot select Hierarchy Node

Symptom

  • User is calling Value Help for planning data (new lines in crosstab) to enter new planning data manually.
  • Value Help (F4 help) does not show Option Buttons for Hierarchy Nodes. Hierarchy Nodes can't be chosen.

hierarchy.jpg

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 BusinessObjects Analysis 2.4, edition for Microsoft Office

  • SAP BusinessObjects Analysis for Microsoft Office 2.5

  • SAP Analysis for Microsoft Office 2.6

  • SAP Analysis for Microsoft Office 2.7

Reproducing the Issue

Click F4 button to call the Value Help on a characteristic in a new line.

Cause

This is current intended behavior in AO. As described in SAP Note 2303212: only hierarchy leaves are allowed for selection, hierarchy nodes are not. Because the distribution on hierarchy nodes along the children (leaves) is not available.

Resolution

Workaround:

Please consider to deactivate the settings below in Hierarchy Attributes(T-code: RSH1) to use the leaf in the new lines. But, please note that this is a different scenario than the feature described in the Symptom.

51.png

Keywords

Analysis for Excel, Analysis for Office, disaggregation, distribution , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , BW-PLA-IP , Integrated Planning , Problem

Product

SAP Analysis for Microsoft Office 2.6 ; SAP Analysis for Microsoft Office 2.7 ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office ; SAP BusinessObjects Analysis for Microsoft Office 2.5