Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II - Page 6
April 10, 2006
32. Right-click the newly renamed Trans Date attribute in the Attributes pane.
33. Select Create Level, as depicted in Illustration 31.
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.
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.
Click for larger image
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.
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.
38. Click OK.
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.
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.
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.
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.
47. Rename the Hierarchy to the following:
The Hierarchies pane, with our latest adjustments, appears as depicted in Illustration 40.
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.