Skip to main content
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