Database Reference
In-Depth Information
Figure 12-26.
Completing your configurations
Browser
After configuring your cube using the various tabs, you need to deploy and process the cube before most changes
will take effect. Afterwards, use the Browser tab to verify that all your configurations have been successful.
Additional Dimension Configurations
We are almost done with our look at how to create and configure SSAS cubes and dimensions, but there are still a
few additional dimension configurations that we think you should know about. These configurations include the
following:
•
Parent-child dimensions
•
Role-playing dimensions
•
Reference dimensions
In Figure
12-27
, we display a database diagram of the tables we use as examples for each dimension type.
The DimEmployees table is used to create a parent-child dimension, the DimCategories table is used to create
a reference dimension, and the DimDates dimension table is used to create role-playing dimensions.
■
We will be using examples from a data warehouse we created for the northwind database. This has the
advantage of helping you with the “learn by doing” exercise at the end of this chapter.
Note
