Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. 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 ?