SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult to dynamically set default parameter that are passed into the dataset being used. It turns out this is a lot simpler to do then many people think. In this post I’ll walk you through the steps of setting a default date value in a dataset’s parameter.
Step One
When creating a dataset that uses Analysis Services you will select Query Designer and then drag over the measures and dimension attributes that are needed for the report where it says “Drag levels or measures here to add to the query” . To add a parameter to the dataset you need to add a filter above where you just dragged over your report fields. In my example I am filtering by the year 2008.
Tags: ssrs