SAP Knowledge Base Article - Public

3047679 - The query has exceeded the maximum number of calculations allowed error happens in story of SAP Analytics Cloud (SAC)

Symptom

Illegal State: {"msg": The query has exceeded the maximum number of calculations allowed.", "args":[]} happens in story when there are more than 200 story calculations in the story.

Environment

  • SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Create more than 200 story calculations in SAC story.
  2. Create table in story to add the dimension and measure into table.
  3. Error below happens in the table:

    Illegal State: {"msg": The query has exceeded the maximum number of calculations allowed.", "args":[]}

Cause

The behavior is by design.
The number of calculations in story reached the limitation in SAC.

Resolution

The maximum number for story calculations in SAC is 200.

See Also

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

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, story, calculation, calculations, maximum, limit, limitation, Illegal,  State , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0