Firsty, thank you so much for these vids. they were more helpful then the MS course I went on.

I have a dimension table called Refreshdate with 1 row and 2 columns. 1st Column is ID(value= 1), and 2nd column is datefield that holds datetime the ETL process was run. Each time the Fact tables are Fully loaded the datefield is updated with the current datetime value. The fact tables has a field called RefreshDateID and it is always 1 obviously.

The raeson for this is that the refreshdate attribute can be dropped on the Filter Field and it tells us how recent the data is.

the problem is that it was working in the 2000 cube and i cant get it to work in AS2005. When I refresh the Pivot the measures update but the RefreshDate value on the Filter Field doesn't refresh to the updated date.

Can you help? or is there a better way to do this?

Update: I've got it to work in the SSAS browser but in excel2003 when I refresh the pivot all the values disappear except the old refreshdate. When I remove the RefreshDatefrom the Filter Group the values reappear. So is it an excel version problem. I really can't in upgrade to Excel2007 and I've installed the Addin for excel2003 but the additional tool doesn't allow me to have more then 1 multiple selections in the Filter Group.

Is there a way around this?