Create
a Virtual Dimension to Enable Dual Axis Reporting
Let's enter the new Crosstab
Reporting cube and set about the creation of a virtual dimension.
1.
Right-click
the Crosstab
Reporting cube in
the cube tree.
2.
Select Edit
from the context menu that appears, as depicted in Illustration 15.
Illustration 15: Select
Edit from the Context Menu ...
The Cube Editor
opens.
3.
Right-click
the Dimensions folder in the Tree pane.
4.
Select New
Dimension from the context menu that appears, as shown in Illustration
16.
Illustration 16: Select
New Dimension from the Context Menu ...
The Welcome page
for the Dimension Wizard appears, as depicted in Illustration 17.
Illustration 17: Dimension
Wizard Welcome Page
The Choose how you
want to create the dimension dialog appears.
6.
Using the
radio button to its immediate left, select Virtual Dimension, as shown
in Illustration 18.
Illustration 18: Select
Virtual Dimension ...