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

You mentioned using this in a virtual cube. If the virtual cube contains
measures from more than 1 cube, you should explicitly specify an
intrinsic measure from the desired cube in IsEmpty() - do all cubes have
data till April?

NOT IsEmpty([Measures].[SomeCubeMeasure]))).Item(0)

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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