One dimension and two measures

Show Me
Karen now needs to perform additional analysis to get the answer to her second question.
How much is ABC selling compared to labor costs?

In this exercise, you will configure a Dimensions view copy, Order Value vs. Labor Cost to analyze the Product dimension against the Order Value and Labor Cost measures.

To configure the Order Value vs. Labor Cost view, complete the following steps:
  1. In the Dimensions view toolbar, click Configure.
  2. From the Subject area list, select the Order Processing subject. The dimensions of the selected subject area are displayed.
    Note: An asterisk * before a Subject Area name means that the corresponding cube is either not defined or not running.
  3. From the Available dimensions list, select the Product dimension, and then click Add to move it to the Row dimensions list.
  4. From the Available dimensions list, select the Measures dimension, and then click Add to move it to the Column dimensions list.
  5. To continue to the next page, click Next.
  6. Right-click the Measures dimension, and then select Member Filter from the pop-up menu.
  7. On the Member Filter window, select the Measures dimension from the Selected Members list, and then click Remove.
  8. Expand the measures on the Dimension Hierarchy tree, select Order Value, and then click Add.
  9. Select Labor Cost, and then click Add.
  10. Click OK. Both the grid and chart display the total Order Value and the total Labor Cost for all products. You can now perform your multidimensional analysis:
    1. To display the measures values for each Product Category, right-click the Product dimension, and then select Drill down from the pop-up menu. Both the grid and chart display the Order Value and Labor Cost per Product Category.
    2. On the chart area, right-click and select Chart Types from the pop-up menu. The Chart Types and Configuration window is displayed.
    3. From the Chart Type list, select Radar, Area, and then click OK.
    4. To hide the grid and show only the chart, click the Grid toolbar button to hide the grid.
    5. To hide the informational text, clear the Show informational text check box.
    6. To save you settings, click Finish.
    7. Right-click the chart area, and select Swap Axis to swap the chart axis for a different chart
The Order Value vs. Labor Cost view displays a chart analysis of the Product dimension against the Order Value and Labor Cost measures.

Next topic: Two dimensions and one measure
Previous topic: One dimension and one measure


Copyright IBM Corporation 2005. All Rights Reserved.