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

Understanding the data source view

The data source view is a very important concept in Analysis Services. You can think of it as an abstraction layer between the relational database and the multidimensional cube. You have the ability to define objects that do not exist in the database. The data source view provides a logical view of the database, so to Analysis Services, the objects appear to exist in the database. This includes new tables, columns, and even referential integrity or relationships between objects.

Tip

In many cases you do not define referential integrity down in the database layer when you work with data warehouses. The reason for this is that loading of the data is much easier without them. If you have defined foreign keys and primary ...

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