Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Nov 11, 2002

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

By William Pearson


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




MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date