topic Re: QlikView and SQL Cube in QlikView

QlikView and SQL Cube

Wed, 19 Dec 2012 08:52:25 GMT

Hi all,

is it possible to create a connection with QlikView 9 to SQL cube and create MDX query?

On QlikView 11 it works. But if I replicate the connection to SQL cube and the MDX query on QlikView 9 script, it doesn't work!

It is a limitation of QlikView 9 or the syntax in QlikView 9 is different from QlikView 11?

Thanks all.

Re: QlikView and SQL Cube

Anonymous — Wed, 19 Dec 2012 08:59:16 GMT

Hm, last time working with version 9 I think we used openrowset.

here's a thread on the topic:

http://community.qlik.com/message/78305#78305

Re: QlikView and SQL Cube

Wed, 19 Dec 2012 10:04:47 GMT

I have seen the topic, but i don't understand how I can create the connection to the SQL cube. What provider I have to use?

Re: QlikView and SQL Cube

Wed, 19 Dec 2012 11:14:42 GMT

I use this code in the script, but nothing

CONNECT TO [Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=True;Initial Catalog=KPIManagement6;Data
Source=ensv1hsi.eni.pri;MDX Compatibility=1;Safety Options=2;MDX Missing Member
Mode=Error];

SQL SELECT * FROM OPENROWSET

('MSOLAP.4',

'Provider=MSOLAP.4;Integrated
Security=SSPI;Persist Security Info=False;Data Source=ensv1hsi.eni.pri;Initial
Catalog=KPIManagement6;',

'SELECT
( [Measures].[RowCount])

)