SAP Knowledge Base Article - Public

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


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.


  • SAP Analytics Cloud (Enterprise) 


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.


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.


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


SAP Analytics Cloud 1.0