Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II - Page 7

April 10, 2006

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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers