Connecting and Query Microsoft Analysis Services Cubes (MSAS) using MDX

Connecting and querying a Microsoft Analysis Services Cube using MDX results in an error message.
 

Querying a Microsoft Analysis Services Cube using MDX requires wrapping the MDX statement into an openrowset.
Ensure OPENROWSET is enabled on the Microsoft Analysis Services server.
Ensure the correct version of the OLEDB provider "Microsoft OLEDB for Olap Services" is installed on the QlikView client machine.

MDX statements can be wrapped into a two dimensional data set using OPENROWSET similar to this example:
 

SQL SELECT * FROM

openrowset('MSOLAP.3','DATA SOURCE=localhost;Initial Catalog=Adventure Works DW',

'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] )')