How to compare date in cube to a dateprompt value

[jamesqi]

I've created a dateprompt and we have a "calendar years" dimension in my cube. Under "calendar years", we have "quarter","month","week" and "day" levels. I tried to create report which date <= prompt. I used "day" level to compare the dateprompt parameter. It failed. Anybody helps! Thanks.

[MDXpressor]

You have to remember that the cube is not populated with dates, it's populated with Member Unique Names.  If you tried using the tree-prompt instead of the calendar prompt, I think you'd have more success.

[jamesqi]

I'll try this way. Thanks.