I thought it might be helpful to see what I am trying to do....

select [Measures].[Fact Activity Contact Count] on 0,

[Fact Activity].[Sales Person].&[Bentley, Billie] on 1

from [CRM Support]

where ([Dim Time].[Week].&[38] ,

[Dim...

No, I do need all the data in the cube (not just this week), but I wanted the KPI to filter down to the current week.  It may well be...