SAP Knowledge Base Article - Public

3646458 - Data Flow Using Data Access Control returns the error: Cannot add view 'xxxx'

Symptom

Consuming a view with data access control (DAC) on a data flow causes an error, such as "Cannot add view 'xxxx'. A data access control has been applied to this view or a dependent view."

Environment

SAP Datasphere

Reproducing the Issue

  1. Access the Data Integration Monitor
  2. Select the required space
  3. Select tab Flow and then tab Dataflow
  4. Check the validation messages

Cause

Using a view with DAC on a data flow disables data protection. This results in a non-ideal data flow process that doesn't function correctly with protected data, and the semantics will be incorrect. Consumption from this view will resemble a snapshot.

Resolution

You cannot use a DAC to transform or transport data via Dataflow.

Review the semantic usage for this view and the data flow. Row-level security from Data Access Control (DAC) can be by-passed while the view stays in its space. It is only enforced when the view is shared with another space or accessed in SAP Analytics Cloud outside its original space.

See Also

Keywords

Dataflows, error message, DS, DT , KBA , DS-DI-DF , Data Flows , Problem

Product

SAP Datasphere all versions