I'm trying to build a report in SSRS that runs against an OLAP cube in an Analysis Services database. This cube has a 'Time' dimension with a year-quarter-month-day hierarchy. Using the MDX query builder in reporting services I'd like to figure out a way to filter on a date range based on the Time dimension and ideally have this as a report parameter. I'd like for the user to pick a start and end date from two date picker controls and have that fed into the filter. This is trivial with SQL but proving difficult with MDX and the cube. Any ideas?