/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
When applying a DAC (Data Access Control) object of type Operators on a Datasphere's model (Analytic Model (AM), or View) a performance degration may happen.
Environment
SAP Datasphere
Cause
It's known that having a DAC with 3k~5k restrictions will cause a linear performance issue, mainly if DAC type is "Operator and Values".
Resolution
It's highly suggested to remodel the way DAC is applied.
The best way would be to guarantee there are not over 3k restrictions for a single user.
A performance improvement might be expected when using "Single Values" instead of "Operator and Values".
Keywords
Hierarchy, boolean operators , KBA , DS-SEC-DAC , Security – Data Access Control , Problem
Product
SAP Datasphere all versions
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)