randy.jaye (9/17/2010)

---

I am trying to build a calculated member in a SSAS cube. I am relatively new to this process so I may not be aware of all the techniques.

The vast majority of our reporting and analysis is ver specific to a "day". And from the "day" being reported against or analyzed, we need an easy way to provide a calculated measure that provide YTD, Prior YTD,etc. based on day the user selects. I am just not clear on how to determine the Total Prior Year Sales based on a supplied date. For example, if user (or report) uses a day of 9/20/2010 then I need to total sales for 2009.

I hope this makes sense. I guess you could call me a newbie.