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:
- In the Dimensions view
toolbar, click Configure.
- 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.
- 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 Measures dimension, and then click Add to
move it to the Column dimensions list.
- To continue to the next page, click Next.
- 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.
- Select Labor Cost, and then click Add.
- 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:
- 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.
- On the chart area, right-click and select Chart Types from
the pop-up menu. The Chart Types and Configuration window
is displayed.
- From the Chart Type list, select Radar, Area,
and then click OK.
- To hide the grid and show only the chart, click the Grid toolbar
button to hide the grid.
- To hide the informational text, clear the Show informational
text check box.
- To save you settings, click Finish.
- 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.