SAP Knowledge Base Article - Public

3105894 - Cross model copy - number of facts exceeded

Symptom

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."

Environment

SAP Analytics Cloud, all versions

Cause

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.

Resolution

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

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/a2a84b3f955b4f6a89af0bfbf0bd8233.html

Keywords

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

Product

SAP Analytics Cloud all versions