Use Microsoft Analysis Service Database

Sat, 02 Oct 2010 10:58:50 GMT

Hello, i m using the personal edition version 9 of qlikview..

in any version of qlikview like 9 / 10.

how to access the microsoft analysis service database cubes with dimensions and measures without use of

mdx query?

Use Microsoft Analysis Service Database

Tue, 05 Oct 2010 23:49:18 GMT

Hi Brijesh,

First of all you need to enable adhoc distributed queries in SQL server for this to work (see the following link):
http://tejasnshah.wordpress.com/2009/03/19/sql-server-how-to-enable-ad-hoc-distributed-queries/

Once you have that configured an MDX statement similar to the following should work :

SQL SELECT * FROM OPENROWSET
('MSOLAP.3',
'Provide=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=False;Data Source=My_AS_Server;Initial Catalog=Adventure Works DW;',
'SELECT {[Measures].[Sales Amount]} ON COLUMNS, {[Product].[Product].Members} ON ROWS FROM [Adventure Works]'
);

I hope this helps.

Rod

topic Use Microsoft Analysis Service Database in QlikView

Use Microsoft Analysis Service Database

Use Microsoft Analysis Service Database