Advanced Visualization: Perspective Analysis
a scatter chart, but designed to provide more detailed and richer information,
a Perspective view in ProClarity allows us to perform analysis centered
on the relationship between two measures, across a set of dimensional
members. Perspective views can provide useful insight into data we
are exploring, in scenarios where we are analyzing large volumes of data,
undertaking quadrant analysis, or anytime we wish to map multiple measures
across a dimension.
As we have already
saved our work in the previous section, we can "refresh" the view
quickly to "start with a new slate," in examining a Perspective
visualization in ProClarity.
Click the Reset
button (shown in Illustration 18) on the main toolbar, just below the
We receive a message
box, confirming our wish to reset both view options and dimensions, as shown in
Click Yes to continue.
The view resets to a
single bar, a graphical representation of the top (or All) rollup
amount, whose nature is similar to that of the value that initially greeted us
in Part I (with, of course, that view being
in the context of the Decomposition Wizard), when we first established
connectivity to the Budget cube.
Select View --> Advanced Analysis Tools --> Perspective from the main menu, as depicted
in Illustration 20.
Illustration 20: Select View --> Advanced Analysis
Tools --> Perspective
dialog for the Perspective Wizard appears, as shown in Illustration
Illustration 21: The Welcome Dialog
- Perspective Wizard
Wizard - Step 1 of 2 dialog appears, as
depicted in Illustration 22.
Illustration 22: The Perspective
Wizard - Step 1 of 2 Dialog
is here that we select the dimensions that we wish to analyze within the
context of the current Perspective.
Click the Warehouse
dimension to highlight it.
Click the Change
Selection ... button on the Step 1 of 2 dialog.
Selections dialog appears.
Expand the All
Warehouses level by clicking the "+" sign to its immediate
Expand the USA level by clicking the "+"
sign to its immediate left.
10. Click+Shift to select the three states
located under the expanded USA simultaneously.
Selections dialog now appears as shown in Illustration 23.
Illustration 23: The Change
11. Click OK to accept changes.
We are returned to the
Perspective Wizard - Step 1 of 2 dialog,
where we see confirmation of the Warehouse states' selection.