Browsing the Deployed Cube

In the following task, you browse the Analysis Services Tutorial cube.

To browse the deployed cube

1.      Switch to Cube Designer in BI Development Studio by clicking the Analysis Services Tutorial cube.

2.      Select the Browser tab, and then click Reconnect on the toolbar of the designer.

The left pane of the designer shows the metadata for the Analysis Services Tutorial cube. Notice that Perspective and Language options are available on the toolbar of the Browser tab. Notice also that the Browser tab includes two panes to the right of the metadata pane: the upper pane is the filter pane, and the lower pane is the data pane.

The following image highlights the individual panes in Cube Designer.

Individual panes in Cube Designer

3.      In the metadata pane, expand Measures, expand Internet Sales, and then drag the Sales Amount measure to the Drop Totals or Detail Fields Here area of the Data pane.

4.      In the metadata pane, expand Product.

Notice that the attribute and user hierarchies are organized into display folders in the Product metadata list.

5.      Drag the Product Model Lines user hierarchy to the Drop Column Fields Here area of the data pane, and then expand the Road member of the Product Line level of this user hierarchy.

Notice that the user hierarchy provides a path to the product name level.

6.      In the metadata pane, expand Customer, expand Location, and then drag the Customer Geography hierarchy from the Location display folder in the Customer dimension to the Drop Row Fields Here area of the data pane.

7.      On the row axis, expand United States to view the sales details by region within the United States.

8.      Expand Oregon to view the sales details by city within the state of Oregon.

9.      In the metadata pane, expand Order Date and then drag the Order Date.Calendar Date hierarchy to the Drop Filter Fields Here area of the Data pane.

10.  Click the arrow to the right of the Order Date.Calendar Date filter in the data pane, clear the check box for the (All) level, expand 2002, expand H1 CY 2002, expand Q1 CY 2002, select the check box for February 2002, and then click OK.

Internet sales by region and product line for the month of February, 2002 appear as shown in the following image.

Internet sales by region and product line

11.  In the metadata pane, expand Customer, expand Demographic, expand the Commute Distance attribute hierarchy, expand Members, and then expand All.

12.  Right-click the 10+ Miles member, and then click Add to Subcube Area.

Commute Distance appears in the filter pane, above the data pane. The values that are displayed in the data pane are now filtered to show data for customers who commute more than 10 miles. This is effectively equal to the WHERE clause in a Multidimensional Expressions (MDX) query statement. For more information, see MDX Query Fundamentals (MDX).

13.  On the File menu, click Save All.


Mr. Ravi Krishna - Senior Software Engineer
I am a Mocrosoft ASP.net Developer and MCP Certified professional. I have overall 5 years of experience in IT Industry,in that 3 years experience in Microsoft BI(SSAS,SSIS,SSRS). I have experience on various business domains like Automation and Chemical.
https://sites.google.com/site/rkkumardotnet/
Read moreRead more about Contributor