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