Two dimensions and one measure

Show Me
Karen needs the answer to her third question: How much of each product is each customer buying?
In this exercise, you will configure the Dimensions view, Customer Orders by Product, to analyze the Product and Customer dimensions against the Order Value measure.
To configure the Customer Orders by Product view to create this analysis, complete the following steps:
  1. In the Dimensions view toolbar, click Configure.
  2. From the Subject area list, select the Order Processing subject area. The dimensions of the 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 Customer Name dimension, and then click Add to move it to the Row dimensions list.
  5. From the Available dimensions list, select the Measures dimension, and then click Add to move it to the Column dimensions list.
  6. To continue to the next page, click Next.
  7. To filter the measures and view only the Order Value measure, right-click the Measures dimension, and then select Member Filter from the pop-up menu.
  8. On the Member Filter window, select the Measures dimension from the Selected Members list, and then click Remove.
  9. Expand the measures on the Dimension Hierarchy tree, select Order Value, and then click Add.
  10. Click OK. Both the grid and chart display the total Order Value for all products and all customers. Now you can look at the data in several ways:
    1. To display the measure details for each customer, double-click the Customer Name measure.
    2. To display the measure details for each product, double-click the Product measure.
    3. To display the data layout pane, from the view menu bar, select View, and then select Data layout. You use the data layout panel to rearrange the layout of chart axes.
    4. On the data layout panel, drag the Customer Name measure from the Row node to the Column node.
    5. To hide the grid, click the Grid toolbar button.
    6. To hide the data layout panel, from the view menu bar, select View, and then Data layout.
    7. To hide the informational text, clear the Show informational text check box.
    8. To save you setting, click Finish.
The Customer Orders by Product view displays an analysis of the Product and Customer dimensions against the Order Value measure.

Next topic: Summary
Previous topic: One dimension and two measures


Copyright IBM Corporation 2005. All Rights Reserved.