Why isn't this working?
I should know this, I just can't think today. Putting datepart in there
doesn't work, it wants an expression

="Select ...
on columns,
{[Time].[" & DatePart(\"yyyy\", Date()) &"] } on rows
from tableX"

i think that you just want to say this:

Select {Time.Year} on rows from tableX

you need to have a level named year defined in the dimension named time.

Aaron


"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote