Opening a SAS OLAP cube by using the Data menu in Microsoft Excel


The SAS® Add-in for Microsoft Office provides an easy way to connect to your SAS® OLAP Server and display the content of a SAS OLAP cube in the Microsoft Excel PivotTable. It is also possible to open an OLAP cube from within Microsoft Excel without the SAS Add-in. The following instructions describe how to do this while using Microsoft Excel 2010 and connecting to a SAS 9.2 OLAP Server. Other versions of Excel offer this functionality, but they might have a different set of instructions. See the documentation for your version of Excel for details about how to open external data sources into a PivotTable.

  1. Open Microsoft Excel 2010.
  2. Select the Data ribbon.

The data tab is open in Microsoft Excel

3. Select Get External Data ► From Other Sources ► From Data Connection Wizard.

Get External Data, From Other Sources, and From Data Connection Wizard are selected

4. Select Other/Advanced, and then click Next.

Other/Advanced is selected in the Data Connection Wizard

5. Select your SAS OLAP Data Provider. Choose the provider for the release of SAS to which you are connecting. Click Next.

SAS OLAP Data Provider 9.2 is selected

6. Select the Data Source to which you are connecting. The data source is defined in the SAS® Integration Technologies Client for Windows.

7. Enter your user credentials, and then click OK.

Connection is open with user credentials filled in

8. Select the cube that you want to display, and then click Finish.

SalesCube is selected

9. Define how Microsoft Excel should place your PivotTable data, and then click OK.

Where do you want to put the data is filled in, selected to go to the existing worksheet

10. Define the layout of your PivotTable report.