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
- Go to Modeler
- 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