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:
- In the Dimensions view
toolbar, click Configure.
- 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.
- From the Available dimensions list, select
the Product dimension, and then click Add to
move it to the Row dimensions list.
- From the Available dimensions list, select
the Customer Name dimension, and then click Add to
move it to the Row dimensions list.
- From the Available dimensions list, select
the Measures dimension, and then click Add to
move it to the Column dimensions list.
- To continue to the next page, click Next.
- 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.
- On the Member Filter window, select the Measures dimension
from the Selected Members list, and then click Remove.
- Expand the measures on the Dimension Hierarchy tree, select Order
Value, and then click Add.
- 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:
- To display the measure details for each customer, double-click the Customer
Name measure.
- To display the measure details for each product, double-click the Product measure.
- To display the data layout pane, from the view menu bar, select , and then select . You use the data layout panel to rearrange
the layout of chart axes.
- On the data layout panel, drag the Customer Name measure from the
Row node to the Column node.
- To hide the grid, click the Grid toolbar button.
- To hide the data layout panel, from the view menu bar, select , and then .
- To hide the informational text, clear the Show informational
text check box.
- 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.