Chapter 10. Cube Features

This chapter is something of a grab bag of features that build on the foundation of an OLAP cube to provide additional usability for end users. The first section, "Business Intelligence," includes those enhancements that can be added with the Business Intelligence Wizard, including time intelligence (period-to-date, rolling average, and so forth), account intelligence (asset, liability, income, expense), the unary operator (to indicate how values should be aggregated up a hierarchy), attribute ordering, and currency conversion.

Then you'll work with some of the tools available via the Calculations tab. You'll spend some time on calculated members, building measures that derive from other measures. A common example of a ...

Get Pro SQL Server 2008 Analysis Services 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.