SAP Knowledge Base Article - Preview

3575377 - Max result record numbers when consumed 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)


Read more...

Environment

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

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

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.