In SQL 2005, I have a Snapshot cube. Currently, I set the DefaultMember property on the Day dimension of the Snapshot date using this MDX:
Tail(NonEmptyCrossjoin([Snapshot Date].[Day].Members, 1), 1).Item(0).Item(0)
This worked great until I added future dates into my cube. I need the DefaultMember to be todays date and not the last day in the date dimension.
I am used to using MDX with the Format(Now()) to get today's date but can't get the syntax to work on the properties page: Example: [Snapshot Date].[Hierarchy].[Day].&[" + Format(Now(),"yyyyMMdd") + "]
Can anyone tell me how the MDX should look
Linda