SSAS Viewing a Cube in Excel

Using Excel to View Cubes and Configure Pivot Table Reports

Similar to my article SSAS BIDS Cube Browser, Microsoft provides another tool for any end user to view a cube’s measures and dimensions to configure highly analytical reports.

First, use the wizard under the Data tab to configure an connection to your cube.

1-SSAS-Viewing-a-Cube-in-Excel

In the first window, choose your server and authentication.

2-SSAS-Viewing-a-Cube-in-Excel

In the final window, save your connection information and click Finish.

When prompted, select to create a Pivot table within the existing spreadsheet.

3-SSAS-Viewing-a-Cube-in-Excel

You will see a workspace to configure your Pivot tale view of the cube.

I will select the first two measure which automatically display their values in my table area.

5-SSAS-Viewing-a-Cube-in-Excel

To more easily compare the difference between the number of customers I have and their number of order, I will move the values from Columns to Rows to see them displayed above/below each other.

6-SSAS-Viewing-a-Cube-in-Excel 7-SSAS-Viewing-a-Cube-in-Excel

8-SSAS-Viewing-a-Cube-in-Excel

Next, I would like to see those numbers by customer geography so I will add a Customer Geography dimension and move it from the ROWS area to become a filter.

9-SSAS-Viewing-a-Cube-in-Excel 10-SSAS-Viewing-a-Cube-in-Excel

11-SSAS-Viewing-a-Cube-in-Excel

Now I may use the Customers filter to only see counts from USA customers.

12-SSAS-Viewing-a-Cube-in-Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s