SAP Knowledge Base Article - Public

3698260 - "Please don’t repeatedly use more than 1 dimensions in different validation rules" when saving a new validation rule in SAP Analytics Cloud (SAC)

Symptom

  • Error message: "please don’t repeatedly use more than 1 dimensions in different validation rules" occurs when saving a new validation rule.
  • The issue arises when attempting to save a second validation rule using dimensions already used in an existing rule.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Create and activate the first validation rule using dimensions (e.g., dimension 1, dimension 2, dimension 3).
  2. Create a second validation rule using one or more of the same dimensions defined in the first rule (e.g., dimension 1, dimension 2).
  3. Attempt to save the second validation rule.
  4. Observe the error message: "please don’t repeatedly use more than 1 dimensions in different validation rules".

Cause

The issue is caused by a design limitation in SAC, which prevents the use of more than one (i.e. two or more) same dimensions in multiple validation rules.
This limitation exists because two dimensions are sufficient to define a single rule. If the same pair of dimensions is used in another validation rule, it could lead to conflicts between these 2 rules, making it unclear which rule should take precedence. This design ensures consistency and avoids potential issues.   

Resolution

  1. Verify whether the dimensions used in the new validation rule are already defined in an existing rule.
  2. If the dimensions are already used, modify the validation rule to avoid reusing the same 2 or more dimensions across multiple validation rules.

Keywords

validation rules, sap analytics cloud, planning validation, error message, dimension conflict, rule limitation, validation rule error, save validation rule, planning model, validation rule design, sap analytics cloud planning. , KBA , LOD-ANA-PL-VAL , Planning Validation , Problem

Product

SAP Analytics Cloud all versions