javaught
asked on
SQL reporting services OLAP cube how to query time dimension using date range
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?
ASKER
Pedro
Thank you for the reply. I do not seem to have the dimension available that is in your example. I have a time dimension with several members I can query individually, such as year, month, day, etc, but nothing that combines them. I attached a screen capture showing this. This is why I am having trouble specifying a date range. Is there a way I can add a dimension like the one shown in your example?
time-query.JPG
Thank you for the reply. I do not seem to have the dimension available that is in your example. I have a time dimension with several members I can query individually, such as year, month, day, etc, but nothing that combines them. I attached a screen capture showing this. This is why I am having trouble specifying a date range. Is there a way I can add a dimension like the one shown in your example?
time-query.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The SSRS wizard do all that for you... and you can check the code genereted by it.
Follow the attached images.
Helped?
Regards,
Pedro
www.pedrocgd.blogspot.com
image1.JPG
image2.JPG
image3.JPG
image4.JPG
image5.JPG