
How ASO Works and How to Design for Performance • 265
([Jun], (Period]) as opposed to [Jun], [YTD]). All data is stored in [Period] (which is the
only stored, nonformula member in this dimension). en MDX formulas for [YTD]
and [QTD] redirect queries made against ([Jun], [YTD] ) to ([YTDd(Jun)], [Period])
using concatenation functions. (Note: Only the new [TimeSpan] dimension has been
shown in Figure7.14.)
ere is one issue with these formulas as written. ere is no MDX that translates
queries for ([YTD], [Qtr3]), and the other upper-level members of the [Full Year] hierar-
chy. What should [YTD] be for [Qtr3] be? It is clear, if [Qtr3] is i ...