Introduction to SQL Server 2000 Analysis Services: Working with the Cube Editor - Page 12

November 11, 2002


Let's check the effectiveness of our work by using the Browse feature at the Product dimension.

68.  Right-click the Product dimension in the cube tree.

69.   Select Browse from the context menu, as we did with the Customer dimension earlier.

The Dimension Browser window appears.

70.  Expand All Products, along with a sample of the two levels underneath (I chose All Products -> Baking Goods -> Cooking Oil for illustrative purposes below), to reveal the results of our enhanced Member Name Column expression, as partially displayed in Illustration 50.



Illustration 50: Partial View of the Expanded All Product Level


71.   Click the Close button on the Dimension Browser when finished.

72.   Drag the recyclable_package column from the product table onto the Member Properties folder underneath the SKU level.

The SKU level of the Product dimension appears as shown in Illustration 51:



Illustration 51: SKU Level of the Product Dimension


The addition of the information, which concerns the recyclable nature of the product packaging, to the level member properties will allow us to access the information for reporting and browsing purposes. Classing this data as a Member Property makes it available, albeit not as easily used as a member in its own right. Again, the requirements of the business environment will usually dictate the proper treatment of data fields.

73.  Right-click the Product dimension in the cube tree.

74.  Select Browse from the context menu, once again.

The Dimension Browser window appears.

75.  Expand the All Product, along with a sample of the two levels underneath (again, I chose All Product -> Baking Goods -> Cooking Oil), to see the Member Property displayed to the right of the Member Name Column (in the Member Properties box), as illustrated below.



Illustration 52: Example Member Property Displayed from the Dimension Browser


76.  Click the Close button on the Dimension Browser when finished.


Page 13: Using the Cube Editor to Work with Measures


See All Articles by Columnist William E. Pearson, III









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers