SSAS: BIDS Exploring a Cube

Using BIDS to Explorer Cube Characteristics and Data

With my cube designed and created, I will now leverage the BIDS interface to expose its rich features.
First, I’ll select the Customer dimension to Explore Data.

1-SSAS-BIDS-Exploring-a-Cube

Now I’m presented with a series of sub-tabs which I may use to view Table data, use a Pivot Table, view a Chart, or use a Pivot Chart.

Table

Using the Table sub-tab I may view the dimension’s data, including using the headers to sort.

2-SSAS-BIDS-Exploring-a-Cube

Pivot Table

Next, I may use a Pivot Table similar to that in Excel (link) to configure a report to view customer info and a YearlyIncome filter to view only customers which earn a certain amount.

3-SSAS-BIDS-Exploring-a-Cube

Chart

Using the Chart sub-tab, I can view data in graphical terms. Also, I may change the type of chart use and which attributes to display in the chart.

4-SSAS-BIDS-Exploring-a-Cube

Pivot Chart

Finally, I may use the Pivot Chart sub-tab to add CommuteDistance to see a specific customer’s commute.

5-SSAS-BIDS-Exploring-a-Cube

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