SAP Knowledge Base Article - Public

3575377 - Max result record numbers when consumend by SAP HANA Multi-Dimensional Services (MDS) In Datasphere

Symptom

When SAP HANA Multi-Dimensional Services (MDS) is used to access Datasphere's data sources, such as Analytic Models and Views, from front-end tools like SAP Analytics Cloud (SAC), the SAP Analytics Cloud add-in for Microsoft Office, or SAP Analysis for Microsoft Office, the following errors are recorded in the HTTP archive (HAR) file trace within the browser's developer tools:

  • The selection returned more records than the limit in MaxResultRecords : The selection returned more records than the limit in MaxResultRecords : Number of data records exceeded
  • The Cube that exceeds the limits contains the following dimensions : Rows:...
  • The selection returned more records than the limit in MaxResultRecords : actual/query/default = <Number of selected Records>/1000000/1000000
  • The selection returned more records than the limit in MaxResultRecords: :10000000/ <Number of selected Cells>  (during createTuplesByAxisCrossJoin)

Environment

  • SAP Datasphere
  • SAP SAP Analytics Cloud
  • SAP Analysis for Microsoft Office
  • SAP Analytics Cloud, add-in for Microsoft Office

Cause

Limitation in the underlying HANA databases belong to SAP Datasphere.

Resolution

The limitation is controlled by MDS parameters in HANA database as per SAP Note 2770570.

The parameters cannot be changed in the underlying HANA database belong to Datasphere. Reduce the table result data amount to avoid the error message. This can be done by  reducing the number of tuples/cells returned by simplifying the query:

  • Reduce the number of dimensions on the axes.
  • Reduce the number of exception aggregation dimensions.
  • Reduce the number of measures/accounts requested.
  • Add more restrictive filters
    • for dimensions which are on an axis,
    • for dimensions which may, directly or indirectly, be used as an exception aggregation dimension.

See Also

  • SAP Note 2770570 Error message "The select returned more records than the limit in MaxResultRecords" / MDS Cube resultset & cell size limit
  • KBA 3395691 Error message "The data can't be displayed because too many records are returned" 
  • KBA 2729600 The data cannot be displayed ... error when refreshing a story with many widgets and/or data in SAP Analytics Cloud (SAC)

Keywords

Max Result Records,  Max cells number,  , KBA , DS-MD-AM , Analytic Model , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , DS-MD-VIW , Views , Problem

Product

SAP Analysis for Microsoft Office all versions ; SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions ; SAP Datasphere all versions