Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jaweher89
New Contributor II

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

Re: Connecting to Qlik Sense app SSAS cube using data load editor

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

above SQL Selelct  except conncetion string comment lines

Community Browser