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.
- Try one of the following solutions:
- Error message: "The number of entities (<number>) exceeds the limit (1000)."
Environment
-
SAP Analytics Cloud (Enterprise) 2025
- SAC Predictive Smart Predict
Reproducing the Issue
- Navigate to System - Job Monitor
- Identify failed multi-action runs.
- Open the run details and confirm the error message: "The number of entities () exceeds the limit (1000).
Cause
Resolution
1. Reduce the number of entities to fewer than 1000 by selecting fewer dimensions or using a combination that produces fewer distinct entities.
2. Refine the data source to remain within the 1000-entity limit.
3. Add Entity Filters to limit the scope and run multiple predictive models, each forecasting fewer than 1000 distinct entities.
4. If needed, split the data upfront in the planning model to process entities in chunks of 1000 or fewer.
5. Before running, verify the member counts of selected dimensions/attributes and add explicit Entity Filters to avoid large queries.
See Also
- How Many Forecasts can be Requested?
- Get Distinct Predictive Forecasts per Entities For your Planning Model
- Restrictions with Predictive Planning
- Restrictions
- KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- SAP Analytics Cloud Connection Guide
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support
Your feedback is important to help us improve our knowledge base.
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
SAP Knowledge Base Article - Public