Symptom
- Error occurs when attempting to export model data to a CSV file in SAP Analytics Cloud.
- Error message: The selection returned more records than the limit in MaxResultRecords: The selection returned more records than the limit in MaxResultRecords: during cross-join of axes; allowed number of tuples: 10000000; actual number of tuples: xxx We couldn’t complete your export job because the number of exported rows is more than the limit. Please go back to the Export Model dialog to filter out some data.
- We couldn't complete your export job because the number of exported rows would be xxx more than the 6 million limit. Please go back to the Export Model dialog to filter out some data.
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Go to the model in SAP Analytics Cloud.
- Open the Data Management workspace.
- In the Export Jobs section, select "Export Model as File".
- Create a New Schedule.
- Attempt to export the data.
Cause
Too many records to export, exceeding the system limitation. The export limit depends on the type of data being exported.
- If calculations aren't included in the export job, the default export limit is 6 million rows.
- If account calculations are included, the default limit is 1 million rows.
Resolution
- When export Model data, go to Select Data dialog to filter out some data. The export can take a long time, but you can use other SAP Analytics Cloud features while you're waiting.
Keywords
sap analytics cloud, export model data, csv export error, 42709 error, maxresultrecords limit, data management workspace, export job failure, tuple limit exceeded, sap_xpa_account, sap_xpa_cost_center, sap_xpa_profit_center, cross-join axes error. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public