3572278 - Performance issue exporting data from SAP Analytics Cloud using a BW Live Connection

When trying to export data to CSV from a BW Live model on SAP Analytics Cloud, the file takes several minutes to be generated and downloaded, while as the SAC story takes less time.

• SAP Analytics Cloud
• SAP Business Warehouse
• SAP BW4/HANA
• SAP Netweaver

1. Create a Story on SAP Analytics Cloud
2. Insert a BW Live Model
3. Confirm it takes some minutes to load (e.g. 10 minutes)
4. Click on export Scope: All
5. Confirm it takes much longer to load (e.g. 50 minutes)

SAC Table widget has a paging mechanism which will not load all data at once to the story to improve the performance.

However, once the user tries to export the data using Scope: All, it means that all data from the underlying BW Query or CDS view will have to be sent to SAC and downloaded from the browser. This is the reason why it will take more time compared to other tools like SAP Analysis for Office for example which use a different type of connection. Specially if the query has a very large amount of data (e.g. more than 50000 records).

The performance of the export file generation should be the same as the performance of the query execution on transaction RSRT.

When it comes to export data, the performance should be compared to the performance of the same query in transaction RSRT.

Use the same variables (prompt selections), filters, dimensions and keyfigures (measures) on the drilldown and then check how long does it take to run the query.

Although SAC export limit is 10 million cells, as per SAP Help: Export Data. On the same Help Page on topic Export Table Data as a CSV or XLSX File one can see: "live data may take some time to export, because it must be downloaded before it can be exported."

Additionally, it is important to keep in mind that the BW Queries were not created to handle a huge amount of data. Exporting larger queries will be possible but it can take longer to load.

More details can be found on KBA 1968598 - Mass data in Bex queries: Options and Workarounds

• SAP Help: Export Data
• KBA: 1968598 - Mass data in Bex queries: Options and Workarounds 

export, xlsx, scope, point of view, query, cds, story, live data, ina, cloud analytics, sapanalyticscloud, optimized story experience, OSE, optimized design experience, ODE , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem