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 Feb 12, 2007

Mastering Enterprise BI: Time Intelligence Pt. I - Page 7

By William Pearson


Review the New Time Dimension Structure and Underlying Table

Review the Time Dimension within the Designer

1.  Right-click the newly created Date dimension (Date 1.dim) within Solution Explorer.

2.  Click Open from the context menu that appears, as depicted in Illustration 39.

Illustration 39: Opening the Dimension Designer for the New Date Dimension

The Dimension Designer for Date 1.dim opens, defaulting to the Dimension Structure tab. Here are presented the Attributes, Hierarchies and Levels, and Data Source View panes, as shown in Illustration 40.

Illustration 40: Panes of the Dimension Structure Tab

From this perspective, we can examine virtually any detail of the structure of the new Date dimension. In addition, from the Data Source View pane, we can at least partially verify the fact that, not only has an underlying table has been created, but the table has been populated with data, based upon the date ranges we provided when creating our cube.

3.  Right-click the Date_1 table appearing within the Data Source View pane of the Dimension Structure tab.

4.  Select Explore Data from the context menu that appears, as depicted in Illustration 41.

Illustration 41: Select Explore Data ...

A sample portion of the data loads, and the Explore Date_1 Table tab appears. Various tools present themselves within its sub tab region (including the default Table tab, a Pivot Table tab, a Chart tab, and a Pivot Chart tab), as shown in Illustration 42.

Illustration 42: The Explore Date_1 Table Tab (Partial View), Displaying Data from the Table

5.  When finished examining the data, right-click the Explore Date_1 Table tab.

6.  Select Close from the context menu that appears, as depicted in Illustration 43.

Illustration 43: Closing the Explore Date_1 Table Tab

Having examined various aspects of the support for the new Date dimension within the design environment, we will next take a look at the underlying table within the Database Engine. We will accomplish this in the section that follows.

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