Create a Cube with Basic Objects
Create a Cube
We will create a basic
cube, with measures we will add as a part of cube creation, within which we
will create the Perspectives which form the focus of our practice
session. We will concentrate upon other areas within the overall design and
creation process in other articles of the series our primary objective here
is to gain some familiarity with Perspectives not to concern ourselves
with the myriad other options and topics contained within general cube design
the Cubes folder within the Solution Explorer.
Cube ... from the context menu that appears, as depicted in Illustration 23.
Illustration 23: Select
New Cube to Begin Cube Creation
The Welcome to the
Cube Wizard dialog appears, as shown in Illustration 24.
Illustration 24: The
Welcome to the Cube Wizard Dialog Appears ...
Ensure that Build
the cube using a data source checkbox is selected on the Select Build
Method dialog that appears next, along with the Auto build checkbox,
and with Create attributes and hierarchies selected in the drop-down
selector underneath the Auto build setting.
default settings are depicted in Illustration 25.
Ensuring the Default Settings on the Select Build Method Dialog
the Data Source View we have created, Adventure Works DW, is
selected within the Available data source views list on the left side of
the Select Data Source View dialog, which appears next. (The tables
contained within the Data Source View are displayed on the right side of
The Select Data Source
View dialog appears, as shown in Illustration 26.
Illustration 26: Select
AdventureWorks DW as the Data Source View
Wizard begins scanning the relational schema, identifying fact and
dimensional tables, as indicated on the Detecting Fact and Dimension Tables
page that appears next. We quickly receive a message indicating that the Wizard
has completed its analysis of the relationships between tables in the Data
Source View, and that it proposes its suggestions on the following page, as
depicted in Illustration 27.
Illustration 27: The
Detecting Fact and Dimension Tables Page Indicates Completion ...
Fact and Dimension Tables dialog next appears. Let's select a Time
dimension table, and narrow the table selection somewhat, for the purposes
of our rudimentary cube.
Select the DimTime
table in the drop-down Time dimension table selector.
Uncheck the following checkbox:
Dimension Column: DimCurrency
NOTE: We can also make table selections graphically via the Diagram
tab of the Identify Fact and Dimension Tables dialog.
The Identify Fact and Dimension Tables dialog appears, as shown in Illustration 28.
Illustration 28: The
Identify Fact and Dimension Tables Dialog, with Our Modifications
Time Periods dialog appears.
unspecified columns blank, select the Time Table Columns values shown in
Table 1 for each of the listed Time Property Names.
Table 1: Selections within Respective Time Table Columns in
Select Time Periods Dialog
The Select Time Periods dialog appears, with our selections, as depicted in Illustration 29.
Illustration 29: The
Select Time Periods Dialog, with Our Selections
Measures dialog appears next.
Uncheck the following checkboxes:
The Select Measures dialog appears, as partially shown in Illustration 30.
Illustration 30: The
Select Measures Dialog (Partial View), with Adjusted Selections
Hierarchies page appears next, as hierarchy detection begins. We receive
rapid indication that dimension tables have been scanned and hierarchies
detected, as depicted in Illustration 31.
Illustration 31: The
Detecting Hierarchies Page, with Indication of Relationships Detected
move to the Review New Dimensions page, which appears as shown in Illustration
Illustration 32: The
Review New Dimensions Page
the Wizard page appears next.
default Cube name to the following:
the Wizard page appears as depicted
in Illustration 33.
Illustration 33: The
Completing the Wizard Page
Wizard concludes, and the Cube Designer opens, as shown in Illustration
Illustration 34: The Cube
Designer Opens ...