Skip to Content
Author's profile photo Former Member

SAP BO DS: Validate data in planning application.

This document explains how the entered data in Design Studio planning application can be validated.

Unfortunately in Design Studio there is no standard method for data validation. It is not possible also to implement the validation on Data Source (Query) level.

Steps to implement data validation:

1.   Define exceptions in the query – this step is optional. The exceptions in the query allow you to use the conditional formatting in Crosstab UI of Design Studio.

DS validate 1.jpg

2.   Add the query as a data source to the application

DS validate 3.jpg

3.   Bind the data source to a CROSSTAB UI

DS validate 4.jpg

4.   Set the property “Conditional formatting visible” of the crosstab to “true” – this setting will color the cells with wrong values, but it won’t stop the saving of the wrong data.

DS validate 5.jpg


DS validate 6.jpg


5.   The saving of the wrong data can be preventing only by checking the all values one by one.

DS validate 7.jpg

6 .  And in the end – if there is no error, call Save method

DS validate 8.jpg

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.