Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sugaz007
Starting Member
2 Posts |
 Posted - 2010-07-06 : 12:24:10
|
| 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-SQLdeclare @date datetimeSELECT * FROM factable where @date between Startdate and EndDateHow do i translate above in MDX to retrieve records from the cube. Please help. Regards, Sugavaneswaran.S |
|
|
|
|
|
MDX _ Filter by Dates