Chapter 9. Working with Time
After completing this chapter, you will be able to:
Explain the requirements for effective time-based analysis in Analysis Services
Employ MDX functions to calculate common time-based metrics
Combine time-based expressions to assemble complex metrics
Time is a critical component of business analysis. Analysts interpret the state of the business now, often in relation to what it was in the past, with the goal of understanding what it might be in the future.
To support this, Analysis Services provides a number of time-based MDX functions. Using these functions, powerful metrics can be assembled. In this chapter, you learn how to employ the time-based MDX functions to calculate some of the more frequently requested of these ...
Get Microsoft® SQL Server® 2008 MDX 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.
