Database Reference
In-Depth Information
After clicking the Next button, you have a chance to rename your Event ID column to a friendlier name. This
is how the column will appear in reporting applications. Because the reporting application will see the value of
the name column, keeping the name EventId is not logical, so we change it to Event.
Clicking the Next button once again brings you to the final page of the wizard, which allows you to name the
dimension and finish the wizard.
We need to create a dimension for the dates as well. To do this, we once again start the wizard and proceed
through its pages, but this time we use the fact table as a dimension table. We do this because all the dates we
need are in the fact table. As you can see from this example, a fact table can occasionally be used as a dimension
table. We will tell you more about this in Chapters 4 and 9.
Creating Cubes
Creating a data source, a data source view, and the dimensions are all preparatory to creating a cube. The act of
creating a cube is done using another wizard (Figure
2-52
).
Figure 2-52.
Using the SSAS Cube Wizard
