I have a shared time dimension for all of my cubes. The default member
is defined as the latest month for which data appears in the cube's
fact table, as follows:

Tail(Filter([Time_Day].[Month].Members,
NOT IsEmpty(Time_Day.CurrentMember)),1).Item(0)

One of my cubes is no longer "seeing" this correctly. The correct
default should be April 2005 but this cube always defaults to January
2005. This wouldn't be so bad, but I use it in a virtual cube that
references Time_Day.Defaultmember.Prevmember. That is causing the cubes
to display full 2004 total sales instead of the most recent full month.

Anyone have any ideas what could be causing this?

Maureen Adams