SAP Knowledge Base Article - Public

3080967 - Cannot execute the data action due to a large number of facts

Symptom

The following error occurs in SAP Analytics Cloud for Planning (SAC) when you execute a data action:

  • The data action couldn't run because the maximum number of queried facts was exceeded. 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 (Enterprise) 

Cause

This limit applies only if copying calculated accounts/measures or accounts with exception aggregations.
As the error message says itself, the maximum number of queried facts is exceeded.

Resolution

There is no setting to increase or remove the limit.
As a solution, please try to split the data action copy step into two separate ones (using the filters).

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, formula , KBA , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud 1.0