SAP Analytics Cloud 2000 rows limit

[mturan]

Hello,

I'm trying to create model for SAC.when I try to import my excel file (almost 188.000 rows ) it only shows 2000 rows.

Is there any option to increase the row limit?

[TammyPowlas · Accepted solution]

I think it does the first 2000 as a sample to validate your data. It will load all the records once you validate/create the model pending meeting system requirements outlined here: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d703...

Good answer here from Rene: https://answers.sap.com/questions/12666188/how-much-data-can-you-import-into-sap-analytics-cl.html

Data Connectivity – Import

Data Acquisition Maximums:

• Columns: 100
• Rows: 800,000 (when importing from CSV and XLSX files, there is a limit on file size, but not on the number of rows)Note This limitation doesn't apply to importing data from all versions of SAP Business Planning and Consolidation.
• Dimension members:
  • Planning models: 1,000,000
  • Analytic models: if there are more than 1,000,000 unique members, the dimension will be made read-only
• Dimension members with geo enrichment: 200,000
• Dimension members with parent/child hierarchy: 150,000 (for other kinds of attributes, the 1,000,000 limit applies)

Blending with two or more imported models - do not know, do not think there are any limitations

Live connections

[tilted · Accepted solution]

Is this up to date?