SYMPTOM:
Microsoft Analysis Services 2014 is a supported data source in Strategy 10. If MDX Cube Provider(IIS) is hosted on the same machine as Microsoft Analysis Services 2014, however, the connectivity cannot be established.
CAUSE:
One of the requirements to connect to Microsoft Analysis Services 2014 is to install the 2012 SP2 version of the Microsoft Analysis Services OLE DB Provider. As Microsoft Analysis Services 2014 installs 2014 version of the OLE DB Provider, two versions of the OLE DB Provider (2012 SP2 and 2014) are installed on the machine where MDX Cube Provider resides.
As the newer version of the OLE DB Provider will take precedence, MDX Cube provider will use the 2014 version, which leads to the connectivity error.
ACTION:
The Datasources.xml file can be modified so that the 2012 SP2 version of the OLE DB Provider will be utilized by IIS.
<DatasourceType>3</DatasourceType>
<ProgramID>MSOLAP</ProgramID>
<MaxXMLSize>1000</MaxXMLSize>
Related external link
https://msdn.microsoft.com/en-us/library/dn140245(v=sql.120).aspx
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
