Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II - Page 7
April 10, 2006
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.
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.
5. Expand the < 30 Aged Period "bucket" to expose the Ship Date members within it, as partially shown in Illustration 43.
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
Lets 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.
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.
2. Right-click the cube within the Solution Explorer tree.
3. Select Process ... from the context menu that appears, as depicted in Illustration 46.
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.
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.