Skip to Content
Microsoft® SQL Server® 2008 MDX Step by Step
book

Microsoft® SQL Server® 2008 MDX Step by Step

by C Ryan Clay Bryan C Smith and Hitachi Consulting
February 2009
Beginner to intermediate content levelBeginner to intermediate
400 pages
9h 59m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 MDX Step by Step

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2008 Analysis Services Step by Step

Microsoft® SQL Server® 2008 Analysis Services Step by Step

Scott Cameron
Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Sivakumar Harinath, Matt Carroll, Sethu Meenakshisundaram, Robert Zare, Denny Guang-Yeu Lee

Publisher Resources

ISBN: 9780735626188Purchase book