Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Author

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

above SQL Selelct  except conncetion string comment lines