O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hiding calculation values on future dates

Time-based calculations are often written either relative to a single member in the Date dimension or relative to a range of members in it. The first scenario includes calculations that return the value of today, yesterday, this month, this year, and so on. The second scenario includes calculations we've already covered in this chapter such as year-to-date calculation and moving averages calculation.

The problem with the latter type of calculations is that they are not empty (the proper term is not null) where they should be - in the future. The term future should be interpreted here as a set of consecutive date members in the end of the Date hierarchy for which no regular cube measure has data.

The problem ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required