Database Reference
In-Depth Information
Chapter 10
Configuring Dimensions with SSAS
O Marvelous! What new configuration will come next? I am bewildered with multiplicity.
— William Carlos Williams
Over the years, we have developed a proven method of creating and configuring SSAS cubes that provides the
least amount of pain and the greatest chance of success. We have already begun our process within the previous
chapter by preparing for the creation of our SSAS cubes by making our data source, data source view, and
dimensions.
In this chapter, we continue this process by configuring SSAS dimensions using the dimension designer.
We also discuss deploying and processing dimension and cubes. Along the way, we verify that the cubes and
dimensions are working as expected and what to do when they are not.
Let's get started with configuring the dimension created in Chapter
9
,
using Visual Studio's Dimension
Designer.
The Dimension Designer
In Visual Studio, dimensions must be created using the Dimension Wizard, but after each dimension is created,
the Dimension Designer is used to complete its configuration. The designer is divided into four tabs (Figure
10-1
):
•
Dimension Structure
•
Attribute Relationships
•
Translations
•
Brower
Let's take a look at each of these and see how they are used in the configuration process.
