In this exercise, you will configure the Dimensions view to display
the analysis of Order Value by product category and product.
An administrator has already created a dashboard named Orders Analysis
by Product Category. The administrator has copied the concrete view and
named the new Dimensions view copy Order Value by Product Category.
You must have access rights in WebSphere® Portal to
perform this task in the configure mode.
To configure the Dimensions view to display the order value by product
category, complete the following steps:
- In the Dimensions view
toolbar, click Configure.
- From the Subject area list, select Order
Processing.
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
on the Selected Members list, and then click Remove.
- Expand the measures on the Dimension Hierarchy tree, select Order
Value, and then click Add.
- Click Apply, and then click OK. Both the grid and chart display the total Order Value for all
products. To perform your multidimensional analyses:
- Right-click the Product dimension, and then select Drill down from
the pop-up menu. Both the grid and chart display the Order Value per Product
Category.
- Right-click the Product Category, and then select Drill down from
the pop-up menu. Both the grid and chart display the Order Value for each
Product under the Stationary Category.
- To save your configuration, click Finish.
The configured view displays the order value for products per product
category.