Today, while digging into time intelligence wizard-generated scripting, I discovered that Analysis Services 2005 has a new syntax for range operations that give us more flexiblity. You can define a range of members like “all members from X to the end” placing NULL in place of the undefined terminating member (we could imagine this like an infinite keyword).
Now you can write:
Date.Year. : NULL
Time intelligence use it into the Year Over Year calculated member, since this member must be calculated for all the years except the first one.
Date.Year.Members(1) : NULL
I think this sintax will be very useful even in several other circumstances, even if Date dimension is the most important one.
Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2005/09/10/range-operation-with-ssas2005.aspx