SSAS: BIDS Cube Browser

Using BIDS to Configure Cube Reporting

Microsoft provides a cube browser within the Business Intelligence Development Studio (BIDS) which allows a developer to view cubes and construct reports using dimensions and measures.  The functionality is similar to using Excel to view and configure cube reporting.
For this article, I will use the sample data warehouse solution Adventure Works DW.
Upon opening the solution, I select the far-right tab “Browser” which exposes on the left a tree of measures (facts) and dimensions and on the right, an area in which to place both objects to create a highly configurable report.

1-SSAS-BIDS-Cube-Browser 3-SSAS-BIDS-Cube-Browser

Within the Measure I’ll select the Reseller Sales and drag it onto the center area for “Totals or Detail Fields…”

2-SSAS-BIDS-Cube-Browser 4-SSAS-BIDS-Cube-Browser

Now I have a value on which I may build a report.
Out of the Reseller Sales Amount, I wish to see break down by product line. Therefore, under the Product dimension, I’ll drag the Product Line hierarchy onto the “Row” area. Now I have the sales amounts displayed by product line.

5-SSAS-BIDS-Cube-Browser

Also, I may choose to filter by different product lines.

7-SSAS-BIDS-Cube-Browser

Now I wish to filter the product line sales by geographies to see sales by state.
So I’ll drag onto the “Filter” area above the table. Also, I’ll select to see sales for “Alabama.”

6-SSAS-BIDS-Cube-Browser

Finally, out of Alabama’s product line sales, I would like to filter by fiscal years so I’ll drag onto the top “Dimension” area the Date.Fiscal hierarchy from the Date dimension. Next, I’ll select FY 2008.

8-SSAS-BIDS-Cube-Browser

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 )

w

Connecting to %s