Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 ?