Default Members vs Excel

Today we ran into an old problem again. Let's start an AS database with a single Sales CUBE and a TIME dimension (+ several other dims). The TIME dim has a default member: [TIME].[Date].Lastchild) It works perfectly when browsing it in BIDS or SSMS. The problem comes when we want to implement it into an Excel fix report that is published on MOSS. It's important that it's fix , because this way we have to anchor the value of the filter expression. When you drag and drop it at the first...(read more)

Source Click Here.