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
» 
Comment and Contribute
