O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Building Your First OLAP Cube

We’ll now work in the blank disconnected instance and create a cube based on the AdventureWorksDW2008 relational source star schema and data source view that you’ve already created. Although we took quite a bit of time to get to this point, you’ll probably be surprised at how easy creating a cube using BIDS actually is. The interface is really quite easy to use after you gain an understanding of OLAP concepts and modeling. This is why we’ve taken such a long time to get to this point. Probably the biggest issue we saw with customers using SSAS 2005 was overeagerness to start building coupled with a lack of OLAP knowledge. This often produced undesirable results. In fact, we were called on more than one occasion to ...

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