SAP Knowledge Base Article - Public

3105894 - Cross model copy - number of facts exceeded


When executing a Cross-Model Copy action you get the error message stating:

"The data action couldn't run because the maximum number of queried facts was exceeded"

You may also see additional messages such as: "This may be due to a copy step with a large number of copied facts, or an allocation step with many reference dimension members. For allocation steps, please filter the reference dimensions."


SAP Analytics Cloud, all versions


There is a limit to Cross-Model Copy Actions when copying calculated account / measures or those with exception aggregation.

In such cases there is a hard limit for the Cross-Model Copy of 1.000.000 (1 million) records.

The limit may change in the future.


Either execute the copy on a smaller data set by setting memberset filters on dimensions.

Exclude all calculated accounts or accounts with exception aggregation. Often these accounts are not required and removing them should remove this limitation.

See Also


Cross Model Copy  DATAACTION_MAXRESULTRECORDS , KBA , LOD-ANA-PL , Planning , Bug Filed


SAP Analytics Cloud all versions