O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Defining Dimensions and Hierarchies

You are now ready to start defining dimensions and hierarchies to your database. Dimensions are the building blocks for cubes in SSAS. You start by right-clicking the Dimensions object in the Solution Explorer (or choosing Project, New Dimension). You can create a new (standard) dimension or define a dimension that is linked to another SSAS cube or database.

For this example, you will be creating three new cube dimensions, based on the dimension tables you have in your data source views (Time_Dimension, Prod_Dimension, Geo_Dimension). When you choose the New Dimension option, you are welcomed to the Dimension Wizard. You need to build the new dimensions by using your data source views. As you can see in Figure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required