* Posts by Mosha

1 publicly visible post • joined 27 Oct 2007

Hands on with MDX



Hi Mark

You can improve the formula for computing year to date sales even more, if the Time dimension is marked as such. Then you don't need to specify Time.CurrentMember inside YTD, and the formula becomes

Sum(YTD(), Measures.[Units Sold])

Now, if we don't create this as calculated measure, but instead use utility dimension or attribute, which is the best practice for Time related calculations, this could be simplified even more:


Two words instead of seven :)