-
MDX - Filter by dates
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|