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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 ?