SAP Knowledge Base Article - Public

3584219 - Predictive Scenario Failure due to Exceeded Entity Limit in SAP Analytics Cloud

Symptom

  • Multi-action job fails due to the number of entities (<number>) exceeding the limit (1000).
    • Try one of the following solutions:
      •    Select columns or dimensions whose combination results in fewer than 1000 distinct entities.
      •    Refine the content of the data source so that you stay within the limit of 1000 entities.
      •    Leverage Add Filters capability to create multiple predictive models forecasting fewer than 1000 distinct entities each.
  • Error message: "The number of entities (<number>) exceeds the limit (1000)."

Environment

  • SAP Analytics Cloud (Enterprise) 2025
  • SAC Predictive Smart Predict

Reproducing the Issue

  1. Navigate to System - Job Monitor
  2. Check for failed multi action runs in job monitor.

Cause

Restrictions with Predictive Planning
Entities (crossing of multiple dimensions)

For more information on entities, see also Get Distinct Predictive Forecasts per Entities For your Planning Model

  • You cannot select more than 5 dimensions or attributes to create a time series predictive model generating predictive forecast value per entity.
  • The maximum number of entities supported is 1000.

Resolution

  • More than 1000 entities and therefore needs to be handled in chunks (splitting the data upfront in the planning model and/or using specific filters to get down to chunks of 1000 entities)
  • The “workaround” to this problem is when you add dimensions / attributes in the Entity field, you need to check if the number of members of these dimensions / attributes is not too big. If it is big, it’s likely that the query that we fire behind the scenes to retrieve the data will fail. Adding explicit filters in Entity Filters for the different dimensions / attributes reduces the scope of the query and in most case should resolve the problem.

See Also

Refer to the following links for additional information:

  • [Predictive Scenario Link](https://farmers-finsac.us10.hcs.cloud.sap/sap/fpa/ui/tenants/66f0/app.html#/smartpredict&/ps/?resourceId=68358&odelId=68359)
  • [SAP Help Portal](https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/ff7175318b6e488c930a0ed33f937efb.html)

Keywords

Predictive Scenario, SAP Analytics Cloud, Entity Limit, Job Failure, PNC_UOE, Exceeded Limit, Job Monitor. , KBA , LOD-ANA-PR-SP , SAC Predictive Smart Predict , Problem

Product

SAP Analytics Cloud all versions