cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BPC Data Validation before Data save

mohitkhemn
Member
0 Kudos

Hi

I have one query regarding data validation before data save to BPC Input form. Below is the requirement:

In above scenario Line 1 VOLUME is 30, so it should be mandatory for the user to submit the PRICE for Line 2. If user try to Save the data than system should through an Error.

Thanks & Regards,

Mohit.

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Kudos

mkhemnani

One possible option is as below.

In One of the excel cell use the formula ISBLANK() by pointing it to the price input cell. It returns true /false based on if the cell is blank. Now you can check the cell with ISBLANK in BEFORE_SAVE event of BPC. the if condition would be like If Sheets("sheetname").range("A1").value = True, A1 is the cell which will have the ISBLANK(c3), C3 is the price input cell

Refer to the blog below for some guidance

https://blogs.sap.com/2013/08/28/input-schedule-validation-using-epm-add-in-events/

Hope this helps !!

Nikhil