SAP Knowledge Base Article - Public

3792303 - The execution of the data action [...] on version [...] generated too many records

Symptom

The following message is displayed when trying to execute a Data Action:

The execution of the data action "<Data action name>" on version "<Version>" generated too many records in step "<step number here>" ("<Step name here>"). This was caused by the calculation starting from line "<line number here>". The scope of the calculationincludes the following dimensions (with the number of members in parenthesis):
"<Dimension name here>" (<Number of dimension members here>). The number of records that the calculation generated is Number of recorder here>.
The number of fact data involved in the calculation is <Number of records here>. Please further restrict the calcutation scope or ask your administrator to adjust the corresponding configuration parameter.

Environment

SAP Analytics Cloud

Reproducing the Issue

Execute an SAC Data Action which generates a significant amount of records.

Cause

The data action scope is too large and beyond the safety belt limit of SAC.

  • If source dimension filter is not specified on RESULTLOOKUP, that dimension scope follows the default scope.
  • If target dimension filter is not specified on DATA, that dimension scope follows the default scope

Resolution

Refer to the documentation below and reduce the calculation scope:

See Also

Keywords

Data action failing with 1000 Members limit exceeding , KBA , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud all versions