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 5

By William Pearson

14.  Scroll to the bottom of the Dimension attributes list.

15.  Click the check box to the immediate left of the bottom Attribute Name, ANSYS045 Aging Bucket Name, to select it.

16.  Select ANSYS045_Aging_Bucket_Key in the selector to the immediate right of the ANSYS045 Aging Bucket Name selection, designating this as the Attribute Key Column.

17.  Leave the Attribute Name Column at its default of ANSYS045_Aging_Bucket_Name.

The Select Dimension Attributes page appears, with our selections, as shown in Illustration 22.

Click for larger image

Illustration 22: The Select Dimension Attributes Page, with Our Selections

18.  Click Next.

19.  Ensure that the default, Regular, is set within the Dimension type selector on the Specify Dimension Type page that appears next, as depicted in Illustration 23.

Click for larger image

Illustration 23: The Specify Dimension Type Page, Defaulted to Regular Dimension Type

20.  Click Next.

21.  Leaving all settings at default, click Next at the Define Parent-Child Relationship page that appears next, as shown in Illustration 24.

Click for larger image

Illustration 24: The Define Patent-Child Page, Settings at Default ...

22.  Replace the Name on the Completing the Wizard page, which appears next, with the following:

Aged Period

The Completing the Wizard page appears, with our modification, as depicted in Illustration 25.

Illustration 25: The Completing the Wizard Page, with Our New Name

23.  Click Finish.

The Dimension Wizard completes its work, and then dismisses itself. We arrive at the Dimension Structure tab for the new Aged Period dimension, within the Dimension Designer, as shown in Illustration 26.

Illustration 26: The New Aged Period Dimension – Dimension Structure Tab

24.  Right-click the new ANSYS045 Aging Bucket Name attribute, appearing just under Aged Period in the Attributes pane.

25.  Select Rename from the context menu that appears, as depicted in Illustration 27.

Illustration 27: Renaming the Attribute ...

26.  Replace the existing name with the following:

Aged Period

The new name appears in the attribute caption box as shown in Illustration 28.

Illustration 28: The New Name is Assigned ...

27.  Right-click the Dim Time attribute, appearing just under the newly renamed Aged Period attribute in the Attributes pane.

28.  Select Rename, as before.

29.  Replace the existing name with the following:

Trans Date

The Attributes pane appears, with our modifications, as depicted in Illustration 29.

Illustration 29: New Names in the Attribute Pane

Having created a new Aged Periods Dimension to serve as the structure for our new aging capabilities, we now need to create and populate a Hierarchy to house the Named Calculations we created in Part I to act as our "aging buckets." We will accomplish this in the next steps.

30.  Right-click the newly renamed Aged Period attribute in the Attributes pane.

31.  Select Start New Hierarchy, as shown in Illustration 30.

Illustration 30: Creating a New Hierarchy in the Dimension

A new Aged Period hierarchy appears in the Hierarchies and Levels pane of the Aged Period Dimension Structure tab of the Designer for the Aged Period dimension.

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