O'Reilly logo

Getting Started with SQL Server 2012 Cube Development by Simon Lidberg

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

Adding dimensions to the FirstCube project

A dimension in Analysis Services is a group of characteristics that describes a fact row. Previously, when working with the FirstCube project in this book, you have worked with dimensions such as date and product. These have all been dimensions with a direct relationship to the fact table. However, several other types of dimensions can be used in Analysis Services. In this chapter, we will add dimensions of different kinds to the cube.

Adding referenced dimensions

Sometimes, you do not have a direct relationship between the fact table and a dimension. An example of this is the Geography dimension. There is no GeographyKey column in the FactResellerSales table, instead, this column exists in the DimReseller ...

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