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:
Date
filter in the filter pane. We will need the same dimension and hierarchy, that is, [Date]
and [Calendar Year]
respectively. You may need to delete the existing filter we created previously.Date
filter as a dataset parameter.You may notice that the report designer now includes a report parameter named @DateCalendarYear
as shown in the following screenshot:
3.144.255.87