SAP Knowledge Base Article - Public

3249585 - Import from File Server or Excel not loading in SAP Analytics Cloud (SAC)

Symptom

  • Data import via MS SQL Server doesn't load/hangs
  • Data import via excel file doesn't load/hangs in SAP Analytics Cloud (SAC)

Environment

SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Go to Modeler
  2. Attempt import via File Server or Excel file

Cause

The issue of the import hanging is due to a particular query which causes poor performance.

For example, a WHERE NOT IN condition may cause poor performance.


Resolution

Rewriting the query to improve performance.

For the example above, removing the NOT operator from the WHERE clause will improve performance. 

See Also

SAC, Error, Issue, Data, Unable, Connection, Connector, Connect, Import, Live, Acquisition, Setup, Model, Failure, Stopped, Loading

Keywords

KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0