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

February 12, 2007


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.