Introduction to MSSQL Server 2000 Analysis Services: Custom Cubes: Financial Reporting - Part II - Page 9

February 17, 2003

At this stage, let's focus upon the Product dimension. As we determined the case to be for the Store dimension, member naming for the Product dimension will be quite straightforward; we will simply swap the already present Product name for the Product ID that appears in the Member Name Column property.

48.  Right-click the product_id dimension.

49.  Select Rename from the context menu, and change the label to Product.

50.  Click the Advanced tab in the Properties pane.

51.  Select the All Caption property.

52.  Change the All Caption property to read "All Products."

53.  Drag the product_id field from the product table over to drop onto the Product dimension in the cube tree.

54.  Right-click the Product_id level that appears.

55.  Select Rename from the context menu, and type in Product.

56.  Click the Basic tab in the Properties pane.

57.  Select the Member Name Column property.

58.  Click the ellipses button ("..").

The Select Column dialog appears.

59.  Select the product_name column by clicking, as shown in Illustration 41 below.

Illustration 41: Select product_name for the Member Name Column Property

60.  Click OK.

The Properties pane for the new Product level, with the modification we have enacted, should appear as shown below:

Illustration 42: The Modified Properties, Product Level Member of the Category Dimension

Finally, one step remains to make the Revenue cube identical to the Expense cube in all significant respects: the addition of an Account dimension. Next, we'll add the Account dimension, using the Dimension Wizard as we did for the Expense cube, as it allows the creation of a parent-child dimension. Creating the dimension a second time within this lesson will also afford us some more practice with the process.

61.  Click Insert in the top Menu.

62.  Select Dimension, then select New from the cascading menu, as shown in Illustration 43 below.

Illustration 43: Select Insert --> Dimension --> New from the Top Menu

The Dimension Wizard welcome dialog appears, as shown below.

Illustration 44: The Dimension Wizard Welcome Dialog

63.  Click Next.

64.  Choose Parent-Child at the Choose How You Want to Create the Dimension dialog that appears next, as shown in Illustration 45 below.

Illustration 45: Selecting the Parent-Child Radio Button

65.  Click Next.

The Select the Dimension Table dialog appears.

66.  Select the account table.

The Details pane is populated with the column names for the selected account table, as depicted below.

Illustration 46: The account Table Columns in the Detail Pane

67.  Click Next.