How would I specify the default memeber of my Date dim to
be todays year. I have seen examples uysing last sibling
however my date dim goes well into 2005/6. I'm trying to
specify the current year.

Anyone solved this one yet.
TIA.
-mike

Helo Mike,
try to specify something like this(I'm not sure about the syntax, please
check it before using)

StrToMember(CStr(Year(Now)))


--
Hope this helps,
Irina

---------------------------
Disclaimer: This posting is provided 'AS IS' with no
warranties, and confers
no rights.

"Mike Morse" <mike.morse (AT) micromo (DOT) com> wrote

Hi Mike,

Thanks for your post. In the FoodMart 2000 sample database, please try to
use the following MDX statements in the Default member property of the Time
dimension to specify the default member.

Strtomember("[Time].&[" + CStr(year(Date()))+"]")

For more information regarding this issue, please refer to the following
articles on SQL Server Books Online.
Topic: "Set Default Member Dialog Box"
Topic: "StrToMember"

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Thank you
I was unaware of the function StrToMember. Works
perfectly.

-mike