Hi ....

I have a new issue it is something like this.
I have a date dimension with regular levels such as
Year,Quarter,Month,Day
What i want to achieve is that if someone has selected a previous year
lets say 1999 then the measures be shown of the last day of that year
that will be 31-12-1999. This i have some how achieved with the help
of some hard coding in a seperate calculated member and then called it
from my original calculated member.

Now the other thing is if the user selects the current year that is
2003 at the moment. Then the measures show the data of the previous
day. Let me explain. On date dimension he has chosed 2003. Today the
date is 17-12-2003. So i want to see the values of the measure of the
date 16-12-2003.

Can someone help me with this as yes i can get the current date by
using any date function but is there anyway to reach the day of date
dimension dynamically or by passing a value as in hard coded way it
will be something like this.


[DATE].[YEAR].&[2003].&[4].&[12].&[20031216]

So in a way i want to replace .&[20031216] with the previous date.

Hope am able to explain my problem .... waiting for the reply.

Regards,

Harris Moin