Comparing Values over Time

Almost all OLAP cubes contain a time dimension. That’s because almost all business activities take place over time, and it’s always useful to compare where one is with where one was. Not surprisingly, many business reporting requirements involve the use of time, and consequently, MDX supports a large number of functions that facilitate analyzing values with time. In this section, you’ll learn how to use member functions that help you compare values over time. In Chapter 7, you’ll learn how to summarize values over time, such as calculating year-to-date totals.

Calculate Growth from the Previous Period

Calculating growth from one period to another is an extremely common business task. In the context of a hierarchy, ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.