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.
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.
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.
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.
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.
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.