Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gandalfgray
Valued Contributor

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
Contributor II

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

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 ?

Community Browser