O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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

Perspectives

As we mentioned earlier, one hallmark of Analysis Services post-version-2000 is its flexibility and accommodating nature. For example, the ability to have drillthrough actions, role-playing dimensions, and multiple fact tables allows you to use a single cube for a multitude of multidimensional and relational queries. With Analysis Services 2000, each fact table required its own cube, role-playing dimensions did not exist, drillthrough functionality was much more limited, and the lack of proactive caching meant that cube data could not be as fresh as is sometimes necessary.

This notion of a single cube acting as a one-stop shop for all your dimensional data gives rise to an Analysis Services 2005/2008 concept called the unified dimensional ...

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