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

Chapter 7. Designing OLAP Cubes Using BIDS

In Chapter 1 through Chapter 6, we set the stage for you to begin developing Microsoft SQL Server Analysis Services (SSAS) OLAP cubes using Business Intelligence Development Studio (BIDS). In those chapters, we defined business intelligence (BI) and introduced you to some of its terminology, concepts, languages, and process and modeling methodologies. We then looked at other tools you’ll be using, such as SQL Server Management Studio and Microsoft SQL Server Profiler. Now, you’re ready to roll up your sleeves and get to work in BIDS. In this chapter, we’ll tour the BIDS interface for Analysis Services OLAP cubes by looking at the AdventureWorksample cube in the Adventure Works DW 2008 OLAP database. We’ll ...

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