There are situations where we need to allow our report consumers to decide which attribute they want to filter their data with. We use a runtime parameter in these cases. Adding a parameter in a dataset based on a cube in the query designer is as easy as selecting a checkbox.
Let's convert our
Date filter into a parameter:
Datefilter in the filter pane. We will need the same dimension and hierarchy, that is,
[Calendar Year]respectively. You may need to delete the existing filter we created previously.