SAP Knowledge Base Article - Public

2793842 - New Lines Validation on Analysis for Office


 When you open an input ready query with new lines and start to add values on the cells there is no validation for those new values.


SAP Analysis for Microsoft Office 2.7 and newer

Reproducing the Issue

  1. Open a BW input ready query
  2. Enable to input values on new lines
  3. Add a value on the cell

Value is not validated automatically.



The behavior described is the intended behavior.


With Analysis for Office 2.7 developers introduced a new implementation for the new lines validation.
The main objective of this new enhancement is to improve the performance when working with planning and new lines therefore by default the cells are NOT validated (selecte as "None") in any way.

To change the behaviour you can activate the check of the entered data on the Components tab in the design panel. You can select property Planning: New Line Validation and define which data should be checked automatically:

  • None

No automatic check is executed.

  • Member

Automatic check runs whenever a member was changed.

  • Lines

Automatic check runs whenever a line was changed and the derivation is done automatically.


The derivations in this mode can only work if the characteristic relationship is modeled in the BW system.

Values that can't be derived will be replaced with character #, or any other character defined in RSADMIN.

See Also

Analysis Plug-in User Guide


Analysis, Office, Behavior, Baheviour, Planning, New, Lines, validation, member, lines, none , KBA , BI-RA-AO-XLA , Excel Addin , BW-PLA-IP , Integrated Planning , Product Enhancement


SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8