3520581 - Error: "There was an error in the export of ["Model_Name"] to CSV ." when exporting model as file in SAP Analytics Cloud

• When attempting to export the model to a ".CSV" file, the export process fails and the following error occurs:
  
  "There was an error in the export of ["Model_Name"] to CSV. Correlation ID"
  
  
• Under workspace /Model structure/Data foundation, the following message displayed:
  
  "We are having trouble displaying your model data. This model contains a lot of data! Unfortunately, we are not able to display it all in the Data foundation. You can add the model to a story to explore the data."
  
  
• The Model contains a large amount of data, making it impossible to display all of it.

SAP Analytics Cloud.

1. Login to the SAC system.
2. Navigate to the model.
3. Switch to "Data Management" workspace.
4. Go to "Export Jobs" and click on "Export data" > "Export Model As File" > "Create New Schedule"
5. Attempt to export the model on "Export Details" : Export Model to "File Repository" or "File Server" > "Select folder"
6. Click on "Export".
7. Notice the error
   >>"There was an error in the export of ["Model_Name"] to CSV. Correlation ID:"

• Currently, the export of model as ".CSV" file in SAC cannot support a large volume of data.
• If the amount of data in the model exceeds its capacity, the export will definitely fail.
• The export limit depends on the type of data being exported:
  
  • If calculations are not included in the export job, the default export limit is 6 million rows.
  • If account calculations are included, the default limit is reduced to 1 million rows.
    

• To reduce the amount of data to be exported, follow these steps:

1. 1. Go to the "Export Model As File" dialog.
   2. Click on the "Select Data" tab.
   3. Choose specific dimensions and measures that you want to export.
   4. Click "Export"
     

• Ensure that the selected period does not contain a large amount of data. If it does, consider splitting the period. For example, instead of applying the filter for one year, apply it for only one quarter.
• If calculations are used, ensure that the final exported number of rows multiplied by the number of calculation inputs per row is less than the 1 million row limit.
• To reduce the number of calculation inputs for the query, simplify the calculations.

SAC Help Guide - Export Data Source Reference

file server, File Server, Repository, Connection, Data, Import, csv, .CSV, Data management, Schedule, Input, row, Quantity, Amount, Job. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem