cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud - Import and Live Connection Data Volume Limitation

Former Member
0 Kudos
3,472

Dear Experts,

Can you please let me know what is data volume limitation that SAP provide while pulling the data via Live Connection and Import Connection.

This is what I got for Live Connection - Is there any update on this

Data volume constraints

With live connection, data volume is processed in your back-end system. There is no theoretical limitation. Query is executed in back-end system. Query should limit volume returned to Web Browser by applying adequate input control or aggregation.

With Data acquisition, it exists volume limitations as follow:

Data acquisition maximums:

Columns: 100

Rows: 800,000

Dimension members:

Planning models: 250,000

Analytic models: if there are more than 250,000 unique members, the dimension will be made read-only

Dimension members with attributes: 150,000

Dimension members with geo enrichment: 200,000

Dimension members in hierarchy: 150,000

Hierarchy depth: 1,000

This is what I got for Import Connection - Is there any update on this

100MB for XLSX and 250 MB for CSV.

Can I get some more info like from any source system if we pull data and place in SAP SAC server, what is the maximum volume or rows of data we can store at any moment.

View Entire Topic
Kivanc_Oktas
Explorer

Hi Prannay,

Just an update for CSV: Maximum file size for csv is 1 GB. There is no limit on number of rows for csv files. Here you can find latest System Requirements and Technical Prerequisites

Regards,

Kıvanç

Former Member

Thank You Kivanc