Database Reference
In-Depth Information
Figure 11-4.
Selecting the measures to use in the cube
The wizard suggests columns and measures to use by comparing the columns' data types. For example,
Author Order is recommended as a measure because it is a fact table and it has a numeric value. This simple
criteria is how the wizard decides what should and should not be included.
As you can see in Figure
11-4
, Fact Sales Count and Fact Titles Authors Count have been added. The
wizard suggests these additional measures to provide row counts for Fact Sales and Fact Titles Authors for your
convenience, in case you need totals for each. The wizard labels these as Count measures for you, but you can
change the names if you prefer.
Count rows can always be deleted later. And, because measures can be added or subtracted after the wizard
is complete, keeping the default settings as is for this dialog window will not be an issue.
Clicking Next moves you to the Select Existing Dimensions dialog window, as shown in Figure
11-5
. In this
dialog window, you can select one or more of the dimensions you have already created. If no dimensions have
been created, the wizard skips over this dialog window to another that allows you to create simple dimensions
right from the Cube Wizard. (That particular window will not appear in our example, however, because we
already created the dimensions.)
Figure 11-5.
Selecting existing dimensions
