Symptom
How to increase the maximum number of data locking driver dimensions in SAP Analytics Cloud from the default 4 dimensions?
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
Model > Configure Data Locks > Add a new Driving Dimension
After adding 4 dimensions, the menu "Add a new Driving Dimension" is grayed out. The tooltip "You cannot have more than 4 Driving Dimensions" appears.
Cause
- Increasing the maximum number of Data Locking driving dimensions is not enabled by default.
- The maximum number can be changed up to 6 on the customers' tenants upon their requests.
Refer to the Enhancement Request ID: 293177 - Data locks available for more than 4 dimensions - The customers should be aware there can be additional performance implications to unnecessarily including a larger number of dimensions than the default in the lock settings.
Resolution
- Open a support case and request to increase the tenant parameter "MAX_DATALOCKING_DIMENSIONS" on your tenants.
- Note that the higher the number the more likely to affect performance.
Keywords
KBA , LOD-ANA-PL-DLK , Data Locking , How To
Product
SAP Analytics Cloud all versions