SAP Knowledge Base Article - Public

2191927 - Microsoft OLE DB Provider for Analysis Services 12.0

Symptom

  • Unable to connect SAP Crystal Reports 2011 to SQL Server 2014 Analysis Services
  • Microsoft OLE DB Provider for Analysis Services 12.0 is not in the list of options in the OLAP Connection Browser in SAP Crystal Reports 2011

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  • Start Crystal Reports
  • Create a new Connection, Select OLAP, click Add
  • Click Server Type drop-down menu in the Connection Properties dialog

Cause

Microsoft OLE DB Provider for Analysis Services 12.0 is not supported

Resolution

Support for Microsoft OLE DB Provider for Analysis Services 12.0 is planned to be added in version 4.1 (Crystal Reports 2013) SP07

See Also

 2156338 - Microsoft SQL Server Analysis Services not available in the list of OLAP provider in Crystal Reports

Keywords

MS SQL Server 2014, OLAP, AS OLEDB , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013