Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview connect with ssas cube

Hello,

I am very new to qlikview personal edition, ssas project implemented and cube created, now i am going to implementing the connection of cube with qlikview but this error comes..

SQL error: Cannot initialize the data source object of OLE DB provider "MSOLAP.4" for linked server "(null)".

OLE DB provider "MSOLAP.4" for linked server "(null)" returned message "Errors in the OLE DB provider. The data source or location is not valid. Provide a valid server to which to connect."



I AM WRITING THIS QUERY IN EDITOR..

SQL SELECT * FROM

OPENROWSET('MSOLAP.4','Server=BISRVR',

'SELECT { [Measures].[Sales Amount], [Measures].[Tax Amount] } ON COLUMNS,

{[Date].[Fiscal].[Fiscal Year].&[2002]

[Date].[Fiscal].[Fiscal Year].&[2003] } ON ROWS

FROM [Adventure Works] WHERE ( [Sales Territory].[Southwest])')



regards,

brijesh



4 Replies
Not applicable
Author

Bijesh,

See this thread: http://community.qlik.com/forums/p/17673/69091.aspx and these search results: http://community.qlik.com/Search/search.aspx?q=SSAS for more information.

Also, it is preferred for QlikView to connect directly to the fact and dimension tables in SQL Server instead of connecting to cubes.

Hope this helps!

Not applicable
Author

Hi Jason,

The link seems to be not working.

brunomarques
Contributor III
Contributor III

I've got around the problem of accessing SSAS MDX cubes developing my own tool to generate MDX queries. It's available at :

http://xthview.com/index.php/download/

Feel free to use it, feedback is welcome.

Not applicable
Author

Hi

Did Uou 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