Symptom
Under Data Integration Monitor the view persistency log contains the following error message:
{"correlationId":"xxx","errorMessage":"View 'xxx' cannot be persisted because the structure of one or more of its Data Access Controls(DAC) does not support view persistency."}
Environment
SAP Datasphere
Reproducing the Issue
- Deploy a view where DAC is used
- Try to persist the data
Cause
Some Data Access Control structures are not supported by persisted views.
Resolution
You can persist a view if a data access control with structure "Values Only" is assigned to it.
Data Access Control structures "Operator and Values" and "Hierarchy" are not supported by persisted views.
More detailed information in SAP Help Portal Documentation: Persisted Views and Data Access Control.
Keywords
operator DAC view , KBA , DS-DI-VIW , View Persistency and Runtime , DS-SEC-DAC , Security – Data Access Control , How To