Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
Hi Jason,
The link seems to be not working.
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.
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