Hello All,

I have a calculated member called [Last Market Value Date] which returns the
date of a Market Value transaction in the form mm/dd/yyyy


Now I need to get the Adjusted Market Value (a different member of the
account dimesnion) on that same day:


If I was hard coding the date for say 12/21/1999, I could create a
calculated member in the Account dimension as follows:

([Account].[Adj MV], [time].[12/21/1999])


HOW do I use the "calculated" Last Market Value Date to specify the time
dimension in my tuple instead of hardcoding as above?

I am stumped! I have tried everything I can think of short of creating a
custom function.

Thanks in advance

Eric

Check out the StrToTuple function.

tom @ the domain below
www.tomchester.net


"Eric Bowden" <ehbowden (AT) nospamyahoo (DOT) com> wrote