SAP Knowledge Base Article - Public

2805011 - Unable to show more than 10000 data points in Chart in SAP Analytics Cloud (SAC)

Symptom

  • Unable to show more than 10000 data points in Chart in SAP Analytics Cloud (SAC) 

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story with any Chart on one model (either import or live), in which one dimension has more than 10000 members.
    => Only 10000 data points (10000 dimension values)  can be shown. 
    => In the Chrome trace,  there is one parameter "RowTo" setting to 10000 in Definition > SubtSetDescription in the HTTP request.

Cause

  • This is expected that we cap the number of results to 10,000. This is to protect the datasource and response time so that large amounts of data-points are streamed and overplotted in the chart.
  • Furthermore, depending on the chart type, we will further limit the number of data-points using Auto Top N or Auto Limits to reduce the number of data-points actually plotted, and the chart details includes a warning message <!> that indicates that partial data is shown. The N value varies by chart type, for example Bar/Column charts has 500, but for charts like Scatter we don't impose an Auto Top N / Limit other than the 10k cap on the query.

Resolution

Use filters to reduce the data points to be shown in the chart.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, data, point, points, member, value, 10000, max, up to , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0