SAP Knowledge Base Article - Public

2423194 - How to import Excel or CSV files when the file exceeds the maximum file size limitation in SAP Analytics Cloud?

Symptom

Environment

  • SAP Analytics Cloud 2019.8

Resolution

There are multiple ways you can get all your data to SAP Analytics Cloud:

Split the large file into smaller ones:

  1. Split your data source file in different files. Make sure none of them exceeds the current SAP Analytics Cloud limit.
  2. Create a new model selecting the first file of the lot.
  3. Save the model
  4. In the menu Browse > Models > select the saved model and open it.
  5. Go to Data Management
  6. In Draft Sources section, in the right side click the import icon and click File.
  7. Select the second file and upload.
  8. After uploading is finished, the file will come to the Draft Sources section. Click it.
  9. Do the data mapping and set Import Method as Append.
  10. Click Finish Mapping to complete.
  11. Repeat step 6-10 for the other files.

Load your large file into a database first

  1. Consult with your vendor how to create a database to upload your data saved in files.
  2. When you have your database ready, follow the SAP Analytics Product Guide to connect to your database. 

If your issue is not resolved you can start an SAP Analytics Cloud Discussion in the SAP Community.

See Also

    Your feedback is important to help us improve our knowledge base.
    Please rate how useful you found this article by using the star rating feature at the beginning of this article.
    Thank you.

    Keywords

    EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

    Product

    SAP Analytics Cloud 1.0