Chapter 10. Dimension Optimization

Chapter Objectives Estimated time: 1.5 hours
In this chapter, you’ll learn how to

  • Use unique keys to optimize a dimension.

  • Remove joins in a SQL statement.

  • Create a single-level virtual dimension.

  • Create a multilevel virtual dimension.

  • Manage sorting problems within a virtual dimension.

In the mid 1970s, gas prices in the United States increased dramatically, often as much as fivefold. Suddenly, there was a great demand for smaller, fuel-efficient cars. In the 1990s, as gas prices remained stable for a long period of time, the demand for large, fuel-hungry sport utility vehicles increased. A concern over fuel efficiency is directly correlated to the cost of the fuel. Even in the most fuel-conscious times, you want ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step 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.

Start your free trial