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.
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.
I'll try this way. Thanks.