Home > SSAS > Use OLE DB Query & PivotTable in Excel

Use OLE DB Query & PivotTable in Excel

Excel can retrieve data from external data sources via ODBC connection or OLE DB connection.

image

We can use OLE DB query to get cubes in SSAS, or access stored procedures in SQL server.

image

Give it the SQL server name.

image

Let’s pick the PivotTable Report type.

image

We get this PivotTable, and fields are ready to be dropped into the right place.

image

If we do not need to sub-total, then select option None in the Field Settings for each Row Labels.

image

If we don’t need grand totals, uncheck these two options in teh PivotTable Options.

image

Categories: SSAS
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: