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 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.
