Symptom
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.
Environment
SAP Analysis for Microsoft Office 2.7 and newer
Reproducing the Issue
- Open a BW input ready query
- Enable to input values on new lines
- Add a value on the cell
Value is not validated automatically.
Cause
The behavior described is the intended behavior.
Resolution
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
Keywords
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