Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jaweher89
Contributor III
Contributor III

Connecting to Qlik Sense app SSAS cube using data load editor

I have one question about data load editor.

I need to use SSAS cube as data source for my qlik sense app.

I have tried to use Microsoft OLE DB provider for Analysis Services 12.0.

I selected one dimension and pressed "Insert script".

Untitled.jpg

and when I press button "Load data" I receive the following error

Untitled1.jpg

Whereas there no error description can anyone tell what is the reason of error - syntax, provider not correct, or something another?


Thanks in advance.

1 Reply
Not applicable

There is some comma or semi colon or some brakets missing.

above SQL Selelct  except conncetion string comment lines