32. Right-click the newly renamed Trans
Date attribute in the Attributes pane.
33. Select Create Level, as depicted
in Illustration 31.
Illustration 31: Creating
a New Level within the Hierarchy ...
A new Trans Date
level appears underneath the Aged Period hierarchy we created above,
within the Hierarchies and Levels pane of the Aged Period Dimension
Structure tab, as shown in Illustration 32.
Illustration 32: The New
Hierarchy and Level within the Designer ...
All that remains in our "construction
phase" is to add the new Aged Periods dimension to our cube. We will
do so through the following steps.
34. Click the ANSYS045 - Named
Calculations.cube tab within the design environment (to the right of the Aged
Periods.dim tab), as depicted in Illustration 33.
35. Within the Cube Designer, on
the Cube Structure tab, and inside the Dimensions pane (on the
left side of the Cube Structure tab, underneath the Measures tab)
right click the cube (ANSYS045 - Named Calculations) atop the
Hierarchy tree.
36. Select Add Cube Dimension ...
from the context menu that appears, as shown in Illustration 34.
Illustration 34: Adding
a Dimension to the Cube ...
37. Select Aged Period in the
list labeled Select dimension from the Add Cube Dimension
picklist that that next appears, as shown in Illustration 35.
Illustration 35: Adding
the Aged Period Dimension ...
The Add Cube Dimension
dialog disappears, and we see the three dates (Due, Ship and Order
Dates) reproduce themselves within the Hierarchies tab. Each sports
an added numeral "1" to distinguish it from the respective original (each
of which is a member of another hierarchy).
The dates appear as
depicted in Illustration 36.
Illustration 36: Three
New Dates Appear
Because we are only
interested in the Ship Date for aging purposes, per our discussion
earlier, we will discard the other two (although their classification into "aging
buckets" might themselves add value for other reasons).
39. Right-click the new Due Date 1.
40. Select Delete from the
context menu that appears, as shown in Illustration 37.
Illustration 37: Deleting
an Unwanted Date
41. Confirm our wishes to delete Due
Date 1 by clicking OK on the Delete Objects confirmation
dialog that appears next, as depicted in Illustration 38.
Illustration 38: Confirming
the Deletion Action ...
We
return to the Hierarchies tab, from which Due Date 1 has
disappeared.
42. Right-click the new Order Date
1.
43. Select Delete from the
context menu that appears, once again.
44. Confirm our wishes to delete Order
Date 1 by clicking OK on the Delete Objects confirmation
dialog that appears next, as before.
We again return to the Hierarchies
tab, where both unwanted dates have been removed.
45. Right-click the remaining new Ship
Date 1.
46. Select Rename from the
context menu that appears, as shown in Illustration 39.
Illustration 39: Renaming
the Hierarchy that Appears in the Cube ...
47. Rename the Hierarchy to the
following:
Trans Date
The Hierarchies pane,
with our latest adjustments, appears as depicted in Illustration 40.
Illustration 40: The New
Hierarchy within the Hierarchies Pane
We are now ready to
verify that the dimension and hierarchy that we have put into
place are structured as we expect. Once we ascertain that our Ship Dates
appear to have been "collected" into the appropriate "aging
buckets," we will be ready to build / deploy our project, process our
cube, and take a look at the effects of our work via the cube browser within
the Cube Designer.
» 
Comment and Contribute
