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