The purpose of this page is to explain how to implement a Master Data Validation in BPC NW.
The master data validation concept is to prevent you from saving and loading incorrect combinations of dimension members. The configuration for validations is performed via transaction UJ_VALIDATION in your backend system. The configuration is environment-specific.
Navigate to the backend system, enter transaction UJ_VALIDATION in the command field and then press "Enter"
Enter your environment
Click the "Assign Driver Dimension" button and Select Account as an example
Click "Driver Dimension Settings". Then click "BACK".
Then click the "Rule Maintenance" button
Here, double-click the desired dimension and then press "Continue".
The next step is to click "Create Rule". In the "Rule Description" section, type "Account & Category".
In the "Assigned Members" section, click the "Multiple Selection" button on the right hand side. In the resulting pop-up, stay on the "Select Single Values" tab card. Here, click the white square icon at the right hand side of the first line. In the resulting pop-up, scroll down until you find the member(s) of your choice (e.g Actual). When found, double click it.
Then click the "Copy" icon.
Then, make sure the "Use Logic Table" is flagged.
Then, click the "Add Dimension" button. For the first line, open the square icon on the right hand side of the "Dimension" field and double-click the desired dimension in the resulting pop-up.
Then click the black triangle icon in the same row, but for the "Operator" column. Select "=" in the pop-up. Finally, for the "Members" column, open the square icon in the first row and double-click the dimension of your choice.
Then, click "Save Rule" and then click "BACK" twice.
Click the "Turn Validations On/Off" button.
- Click the black triangle for the Model field and, in the next pop-up, click your model.
In the "Validation Switch" section, click the black triangle for any of the three selections or in parallel for all three. In the subsequent pop-up, click "ON".
Finally, click "Save Validation Settings" and then click "BACK" once.
Master Data Validation checks can be executed in Excel or Web by entering some data for the relevant selection and by pressing Save Data. The system then gives an error message when the validation rule is "hurt" like this: