SSRS Gotcha!-Using SSAS Time Intelligence in SSRS Reports

Today I had the opportunity to revisit a problem I encountered previously; but, today was different. Today I found the solution.

Adding Time Intelligence to your SSAS cube using the Business Intelligence Wizard is an easy way to add a whole bunch of useful information to your solution. It is one of my favorite topics when teaching boot camps or quick starts because it adds so much functionality to your Analysis Services solution without a lot of work. One day, I decided to create an SSRS report based on one of my SSAS databases that utilized this feature and encountered a strange error when I tried to filter the result set in the SSRS query designer by adding the time intelligence attribute to the filter screen.