When you use the Create Slice option in SAS Add-In for Microsoft Office, the operation might fail with the following error:

This issue occurs when you use the OLAP Analyzer.

For example, you encounter this issue when you complete steps similar to the following:

1. Open Microsoft Excel and select SAS menu ► Data.
2. Open and analyze a specific OLAP cube that you select in the Data field. Then, select the OLAP Analyzer radio button and click OK as shown in the following image:

3. The OLAP cube is correctly added into the spreadsheet. But, when you try to use the Create Slice option as shown below, the error might occur:

In the Excel.log, the following error appears:

This issue happens only when you try to use the OLAP Analyzer without creating a connection to the server SASApp. If you create a connection to the SASApp server before opening and analyzing the OLAP cube, then the Create Slice option works correctly.

To work around this issue, you can follow these steps:

1. Select Data ► Servers and double-click the SASApp server. You see a green check mark on SASApp as shown in the image below:

2. Go to SAS Folders and select the OLAP cube.
3. Use the Create Slice option.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Add-In for Microsoft Office 8.3 is available at:

A fix for this issue for SAS Add-In for Microsoft Office for Visual Analytics 8.3 is available at:

A fix for this issue for SAS Visual Analytics Add-In for Office 8.3 is available at: