as it is the parameter passed into the MDX query you need to make sure the syntax is correct in MDX. Typically it is in the format of [Your Employee...

I wonder is there any way to do it in Excel 2007 dynamically?

I'm sure I dont want to define pre-defined set for each similar request. I wish there is...

Hi Dan,

Thank you very much for the explanation.

Regards,

George

Alternatively, take a look at this article: Handling Begin and End Times in SQL Server Analysis Services 2008 (http://www.sqlserveranalysisservices.com/OLAPPapers/Handling%20Begin%20and%20End%20Times%20in%20SQL%20Server%20Analysis%20Services%202008.htm)