Creating a picklist
A picklist allows users to select available parameters that can be later passed to the queries for the report. A picklist is commonly used to allow users to select parameters and then pass them to the report's MDX query. The following is an example of a picklist that allows users to pick any resellers:
A picklist serves two purposes: to visually display the captions and to bind each caption to a unique identifier behind the scene. It is this unique identifier that will be passed to the report's MDX query. For the reseller name A Bike Store, for example, its unique member name can be either one of the following:
[Reseller].[Reseller].&[1] ...
Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
