Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gandalfgray
Specialist II
Specialist II

How to avoid "OLEDB connect to MSOLAP" to open dialog?

Hi

I am connection to a MSOLAP cube and fetching some data.

The connect string looks like:

OLEDB CONNECT TO [

Provider=MSOLAP.4;

Persist Security Info=True;

User ID=xxxxxxxxxxxxxxx;

Initial Catalog=Hello there;

Data Source=xxx-sql1-prod;

Location=xxx-sql1-prod

] (XPassword is zzzzzzzzzzzzzzzzzzzzzzz);

It works ok when I load/reload the application, but during the connection a "Multidimensional Connection" wizard pops up prompting me to choose location for the multidimensional database I want to use.

All values needed are prefilled so I just have to click "Next" and "Finish" and the connection is done and the loadscript continues fine.

I would like to get rid of this "Multidimensional Connection" wizard during my loads.

Is there a setting for that in the connection string, or how can I solve this?

1 Reply
dvasseur
Partner - Creator III
Partner - Creator III

I have already connected Qlilkview to an MSOLAP cube and never had such a wizzard popping up, that's wierd ! could you post a screenshot ?