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.
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.
Using the Table sub-tab I may view the dimension’s data, including using the headers to sort.
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.
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.
Finally, I may use the Pivot Chart sub-tab to add CommuteDistance to see a specific customer’s commute.