SAP Knowledge Base Article - Public

3567987 - How to determine the limits on rows for Data acquisition/preparation in SAC?

Symptom

  • How to determine the limits on rows for Data acquisition/preparation in SAC?
  • How to determine whether the limits are governed at model level or Fact table (Source) level

Environment

SAP ANALYTICS CLOUD - 2024.21.14

Resolution

A row in the model is equivalent to a single record in the fact table of the model. When data is imported into the model, each record (or row) in the source data can lead to multiple rows in the model due to data aggregation or additional processing. If you import 2 rows of data, SAC may create 4 rows in the fact table depending on how dimensions and measures are processed (e.g., for each combination of product and measure like "Price" and "Count").
 
Therefore, a row of loaded data may not directly equate to a row in the model due to:

  • Aggregation of data (grouping by dimensions like product or region).
     
  • Transformation (e.g., creating additional measures or attributes).                 

SAC has a hard limit of 2,147,483,647 rows per model. This limit is enforced at the fact table level (the main data storage for numerical facts or measures). If importing more data into the model causes the total row count to exceed this limit, the import will fail.

See Also

Keywords

row limit, data volume management, SAP analytics cloud, fact table, model performance , KBA , LOD-ANA-DES , Story Design & Visualizations , How To

Product

SAP Analytics Cloud all versions