Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hello Were you able to solve the problem? Did you use the addin or what solution?