Hi All,

I have a SSAS 2005 Cube, where one of the dimensions is "As Of". The table
of this dimension has only one record with the timestamp of the update. I
disabled the All Level (IsAggregatable set to False) and also specified the
default member within the dimension. In addition, I've added the ALTER CUBE
command (see below). The default member works find within the SSAS browser;
however, in Excel PTS, the default member is not updated on refresh. The "As
Of" dimension is placed in the Page Area and is changeable if I click on the
drop-down (I see the updated member only).

The same set-up ([Version].[Version].&[1]) worked fine in AS 2000; however,
I could not replicate the same behavior in the new 2005 cube. Any
suggestions? Is this an OLE DB (what Excel is using) bug? Any help would be
greatly appreciated!

Thanks,

Pasha

ALTER CUBE [ANB] UPDATE DIMENSION [Version],
DEFAULT_MEMBER='Tail(NonEmpty([Version].[Version].MEMBERS),1).Item(0)';