Last Year and shifted dates

Hi All,

I'm trying to create LY calc members and while it would calculate properly
when it comes to monthly level, daily level presents a problem. It would not
be fare to compare, for example, 08/26/2008 to 08/26/2007, as there is a
daily seasonality in sales (Tue vs. Sun). Is there a way to build a calc
member that would show LY results for 08/28/2007, which represents a Tuesday,
one year ago?

I can populate a column LY_Date in the date dimension with the corresponding
dates, but how would I incorporate that into MDX? Or is there a better way
of doing this?

--
Thanks,

Pasha