Verification
Review
the "Aging Buckets" within the Dimension Designer to Ascertain that
the Structure Appears as Intended
We can
get to the Dimension Designer quickly from the Hierarchy pane by
taking the following steps.
1.
Expand the new
Aged Period hierarchy in the Hierarchies pane, by clicking the "+"
sign to its immediate left.
2.
Click the Edit
Aged Period link that appears immediately under the expanded Aged Period
hierarchy, as shown in Illustration 41.
Illustration 41: Editing
the New Hierarchy ...
We
arrive within the Dimension Designer for the new dimension, from which
we can easily browse the Hierarchy structure to see that it will meet
our needs.
3.
From the
present location within the Dimension Designer for Aged Period.dim,
click the Browser tab.
4.
Expand the All
level of the hierarchy to expose the "aging buckets" of
the Aged Period dimension, as depicted in Illustration 42.
Illustration 42: The "Aging
Buckets" Appear
5.
Expand the <
30 Aged Period "bucket" to expose the Ship Date members
within it, as partially shown in Illustration 43.
Illustration 43: The
Ship Date Members Appear (Partial View)
6.
Expand additional
"buckets," as desired, to inspect their member Ship Dates.
We see that, from the
perspective of Ship Date ranges stored within the Adventure Works
cube, the "buckets" seem to be collecting correctly.
Deploy
the Project, Process the Cube and Review the Aging Capabilities within the Cube
Browser
Let’s
deploy the project, and then process the cube. Once this has been
accomplished, we can fully leverage the browser that the Cube Designer
makes available to us.
1.
Select Build
--> Deploy Solution from the main menu, as depicted
in Illustration 44.
Illustration 44: Select
Build --> Deploy Solution ...
Processing begins, as we
can see in the Deployment Progress pane. Once deployment has
completed successfully, we see a message to this effect in the Status
area, toward the bottom of the pane, as shown in Illustration 45.
Illustration 45: Indication
of Successful Deployment Appears ...
2.
Right-click
the cube within the Solution Explorer tree.
3.
Select Process
... from the context menu that appears, as depicted in Illustration 46.
Illustration 46: Select
Process ...
The Process
Cube dialog appears. We will leave settings at default, including the Full
Processing designation.
4.
Click Run ...
in the bottom right corner of the dialog (as shown in Illustration 47)
to begin cube processing.
Illustration 47: Click
Run ...
Processing
begins immediately, and the Process Progress viewer appears,
displaying the logged events. Processing completes, and the viewer presents
the green Process succeeded message within the Status bar, as
depicted in Illustration 48.
Illustration 48: Process
Completes Successfully, as Indicated on the Process Progress Viewer
» 
Comment and Contribute
