Book Image

Expert Cube Development with SSAS Multidimensional Models

By : Alberto Ferrari, Marco Russon, Chris Webb
Book Image

Expert Cube Development with SSAS Multidimensional Models

By: Alberto Ferrari, Marco Russon, Chris Webb

Overview of this book

Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Designing simple dimensions


Next, let's build some dimensions. As this is one of the more complicated steps in the cube design process, it's a topic we'll return to again in the future chapters when we need to deal with more advanced modeling scenarios. Right now, we'll concentrate on the fundamentals of dimension design.

Using the New Dimension wizard

Running the New Dimension wizard will give you the first draft of your dimension, something you'll then be able to tweak and tidy up in the Dimension Editor afterwards. The first question you'll be asked, in the Select Creation Method step is how you want to create the new dimension and there are effectively the following two choices:

  • Create the dimension from an existing table or view in your data source (the Use an existing table option)

  • Have SSDT create a dimension automatically for you and optionally fill it with data (the other three options)

The Select Creation Method step of the New Dimension wizard is shown in the following screenshot:

In...