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

SAP Knowledge Base Article - Public

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

Symptom

  • Microsoft SQL Server Analysis Services OLEDB Provider is missing.
  • The Microsoft SQL Server Analysis Services is not listed as a choice to select when creating an OLAP report in Crystal Reports.

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, under the menu "File", select "New - OLAP Cube Report"
  2. In the "OLAP Data" window, click on "Select Cube"
  3. In the "OLAP Connection Browser" window, click on the button: "Add..."
  4. In the "Connection Properties" window, notice the Server Type, does not list: Microsoft SQL Server Analysis Services

    OLAP Report.png

Cause

  • The Microsoft SQL Server Analysis Services OLEDB Provider is not installed, and this is why it is not listed in the OLAP connection that can be used. 

Resolution

  • Download and install the Microsoft SQL Server Analysis Services OLEDB Provider from Microsoft.
     
    The steps below are provided as an example, if you have questions regarding downloading and installing the Microsoft SQL Server Analysis Services OLEDB Provider, contact your MS SQL Server Administtator, or contact Microsoft. 
     
    Example on downloading the Microsoft SQL Server Analysis Services OLEDB Provider, from Microsoft:
          
    1. Go to the Microsoft website at: www.microsoft.com
        
    2. Search for: Microsoft SQL Server Analysis Services OLEDB Provider download
         
    3. Select the link that corresponding to the version of Microsoft SQL Server you are using.
         
    4. The download is generally part of larger download, like a Feature Pack. On the download page, click "Download"
         
    5. In the screen "Choose the download you want", scroll and select the download for the Analysis Services OLEDB. Which is usually an item that contains the abreviation of it: ASOLEDB
           
      For example, for MS SQL Server 2008, it will list an item like: "ENU\x64\SQLSERVER2008_ASOLEDB10.msi"  ( For a 64bit MS Windows )
         
    6. Then click "Next" to download the file.
         
    7. Once downloaded, install the Microsoft SQL Server Analysis Services OLEDB Provider, on the same computer where Crystal Reports is installed.

Keywords

CR, MS Services, OLAP client missing , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016