Symptom
In view persistency monitor screen, the inserted number into data persistence table is different with view preview result in Data Builder.
Environment
SAP Datasphere
Reproducing the Issue
1. Persist the view and check the run details.
- 123456 records inserted into the data persistence table for the view "<view_name>". Memory used: xxx GiB.
2. Preview the view in Data Builder check the result, the number of records is different with the number shown in the run details log. Some cases the number is less, some cases the number is 0.
Cause
This is because there is a Data Access Control is configured on the view.
For the above example, there are 123456 number of records persisted into the data persistence table for this view. But according to Data Access Control, user does not have the authorization to view any data records. As a result, view preview in Data Builder shows 0 data record.
Resolution
This is a system behavior.
For more information about view persistency and data access control, please have a look at below on-line document:
Keywords
"Data Access Control" "Datasphere" "View persistency" , KBA , DS-DI-VIW , View Persistency and Runtime , DS-SEC-DAC , Security – Data Access Control , Problem