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 OLAP Cubes in BIDS

We’re ready now to move to a core area of BIDS—the cube designer. We’ve got a couple of items to review before launching into building our first OLAP cube. We’ll use our two instances of BIDS to look at the development environment in two situations. You’ll remember that the first instance is a disconnected, blank environment and the second is working with an existing, connected cube. We’ll also talk about the uses of the Cube Wizard. Surprisingly, it has been designed to do more than simply assist you with the OLAP cube-building process.

To understand this, we’ll start by right-clicking on the Cubes folder in Solution Explorer for the BIDS instance that is blank (the one that is disconnected). Choosing the New Cube option ...

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