Chapter 8. Refining Cubes and Dimensions

Now that you’ve developed your first OLAP cube, it’s time to explore all the other goodies available in Microsoft Business Intelligence Development Studio (BIDS). You can make your base cube much more valuable by adding some of these capabilities. Be aware that none of them are required, but, most often, you’ll choose to use at least some of these powerful features because they add value for your end users. There’s a lot of information to cover here. In this chapter, we’ll look at calculated members, key performance indicators (KPIs), enabling writeback, and more. We’ll also look at adding objects using the Business Intelligence Wizard. Finally, we’ll look at advanced cube, measure, and dimension properties. ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.