Hi,

Does anyone know of a way that i can create a date dimension that defaults
to the latest date in the dimension and displays that date in the dimension
by default?

They way i currently do it is by using the tail syntax via a calculated
measure. This works fine, but it never displays the actual date, just the
name of the measure, i.e. Latest Day or Yesterday etc...

So i guess i'm asking if there is another way to do this or if i can somehow
dyunamically change the name of the measure to the actual date that it
represents???

Regards
Immy

You can set the Default Member Property of the Time Dimension to the MDX
tail expression you are using:

From SQL 2000 BOL

Indicates the member that slices the datasets returned by queries when
the dimension is not displayed on an axis and no slicing member in the
dimension is specified. If no default member is specified, and the
dimension's All Level property is Yes, the member indicated by the All
Caption property is the default member. If no default member is
specified, and the dimension's All Level property is No, an arbitrary
member of the highest level is the default member.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***