Parameterization from Analysis Services - Cascading Picklists
In this article, we will continue to work with the basic OLAP report we created in Support Parameterization from Analysis Services. Our focus will be primarily to perform a refinement from the perspective of the support we provided from the Analysis Services layer of our integrated BI solution. We will establish cascading picklists within the report we created in Support Parameterization from Analysis Services (just as we will undertake the addition of support for intuitive parameter defaults at runtime in our next article), for greater user-friendliness and overall operational efficiencies. In pursuing this refinement within the support of parameterization from Analysis Services, we will:
- Reopen the sample Report Server project, AdventureWorks Sample Reports, and access the existing sample report we prepared in Support Parameterization from Analysis Services.
- Discuss the utility of establishing cascading parameters within a report to make it more user-friendly and effective.
- Make modifications to the datasets underlying our report parameters to incorporate cascading picklist support.
- Preview the report to observe the effectiveness of our solution in runtime action.