QV CONNECT TO MS ANALYSIS SERVICES

[#1]

Hello !

I wish to connect to our MS analysis services from QV . Would somebody guide me how to achieve the same .

I tried to do the same but though 'test connection' works successfully it is unable to create the data source (using the OLE DB)

Rgds

tapas

[Anonymous]

Dear Tapas,

Were you successful using MSAS cubes in QV?

I get connected to the MSAS server, but cannot see any tables or views on clicking "Select".

Appreciate your feedback.

regs

Reji

[#3]

Hi,

If you want to connect to an Analysis Service cube you need to enable adhoc distributed queries (see the following link for more information):

http://tejasnshah.wordpress.com/2009/03/19/sql-server-how-to-enable-ad-hoc-distributed-queries/

Once you have set that up an MDX query similar to the following should work fine:

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

Hope this helps.

Rod

[#4]

Hi

Did you check O-delta™?

"O-delta™ by DataForce Ltd. is the most comprehensive Solution today for companies to dramatically cut down Time & Money of Connection, Migration & Integration of OLAP (mdx.) data cubes to any QlikView’s models, from months/ weeks to days/ hours !!! Http://www.dataforce-solutions.com The Benefits are: • Minimum need of skills/ knowledge of the current OLAP cubes’ structure • Leverages OLAP cubes development investments • Intuitive, integrated & consolidated view of all BI information as a front end • Mobile availability of old and new BI applications"

http://www.youtube.com/watch?feature=player_embedded&v=dlb6nf0w6TQ

www.dataforce-solutions.com

[Emmanuelle__Bustos]

tapasmaj

Hello Were you able to solve the problem? Did you use the addin or what solution?