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 6

By William Pearson

32.  Right-click the newly renamed Trans Date attribute in the Attributes pane.

33.  Select Create Level, as depicted in Illustration 31.

Illustration 31: Creating a New Level within the Hierarchy ...

A new Trans Date level appears underneath the Aged Period hierarchy we created above, within the Hierarchies and Levels pane of the Aged Period Dimension Structure tab, as shown in Illustration 32.

Illustration 32: The New Hierarchy and Level within the Designer ...

All that remains in our "construction phase" is to add the new Aged Periods dimension to our cube. We will do so through the following steps.

34.  Click the ANSYS045 - Named Calculations.cube tab within the design environment (to the right of the Aged Periods.dim tab), as depicted in Illustration 33.

Click for larger image

Illustration 33: Moving to the Cube Designer ...

35.  Within the Cube Designer, on the Cube Structure tab, and inside the Dimensions pane (on the left side of the Cube Structure tab, underneath the Measures tab) right click the cube (ANSYS045 - Named Calculations) atop the Hierarchy tree.

36.  Select Add Cube Dimension ... from the context menu that appears, as shown in Illustration 34.

Illustration 34: Adding a Dimension to the Cube ...

37.  Select Aged Period in the list labeled Select dimension from the Add Cube Dimension picklist that that next appears, as shown in Illustration 35.

Illustration 35: Adding the Aged Period Dimension ...

38.  Click OK.

The Add Cube Dimension dialog disappears, and we see the three dates (Due, Ship and Order Dates) reproduce themselves within the Hierarchies tab. Each sports an added numeral "1" to distinguish it from the respective original (each of which is a member of another hierarchy).

The dates appear as depicted in Illustration 36.

Illustration 36: Three New Dates Appear

Because we are only interested in the Ship Date for aging purposes, per our discussion earlier, we will discard the other two (although their classification into "aging buckets" might themselves add value for other reasons).

39.  Right-click the new Due Date 1.

40.  Select Delete from the context menu that appears, as shown in Illustration 37.

Illustration 37: Deleting an Unwanted Date

41.  Confirm our wishes to delete Due Date 1 by clicking OK on the Delete Objects confirmation dialog that appears next, as depicted in Illustration 38.

Illustration 38: Confirming the Deletion Action ...

We return to the Hierarchies tab, from which Due Date 1 has disappeared.

42.  Right-click the new Order Date 1.

43.  Select Delete from the context menu that appears, once again.

44.  Confirm our wishes to delete Order Date 1 by clicking OK on the Delete Objects confirmation dialog that appears next, as before.

We again return to the Hierarchies tab, where both unwanted dates have been removed.

45.  Right-click the remaining new Ship Date 1.

46.  Select Rename from the context menu that appears, as shown in Illustration 39.

Illustration 39: Renaming the Hierarchy that Appears in the Cube ...

47.  Rename the Hierarchy to the following:

Trans Date

The Hierarchies pane, with our latest adjustments, appears as depicted in Illustration 40.

Illustration 40: The New Hierarchy within the Hierarchies Pane

We are now ready to verify that the dimension and hierarchy that we have put into place are structured as we expect. Once we ascertain that our Ship Dates appear to have been "collected" into the appropriate "aging buckets," we will be ready to build / deploy our project, process our cube, and take a look at the effects of our work via the cube browser within the Cube Designer.

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