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
SAP Knowledge Base Article - Public