SAP Knowledge Base Article - Public

3451037 - How to increase the maximum number of data locking driver dimensions in SAP Analytics Cloud

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