Hi,

I have 2 date columns - StartDate & EndDate in fact table. So in effect these will go to the fact dimension table.

The user will select a date in the web page and this date will be passed. My MDX query should be able to return the records which satisfy this below criteria

-- T-SQL
declare @date datetime

SELECT * FROM factable where @date between Startdate and EndDate

How do i translate above in MDX to retrieve records from the cube. Please help.

Regards,
Sugavaneswaran.S