Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 10, 2006

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

By William Pearson


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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM