O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, 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

OLAP Cube Creation

A star-schema data mart/warehouse named CompSales2012 is used as the basis of creating the OLAP cube example in this chapter. You can download this data mart, CompsSales2012.zip, from the Sams Publishing website for this book title at www.informit.com/title/9780672336928 in the code listings and sample databases folder. You can easily unzip and attach this database to any SQL Server 2012 database instance. This is not an SSAS database; it is a SQL Server database of a star-schema data warehouse/mart. We use this SQL Server database as the source for the exercises in this chapter. You will build the SSAS OLAP cube yourself (by following the steps outlined here).

You’ll spend most of the construction phase using SQL Server Data ...

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