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:

Creating a picklist

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 live online training, plus books, videos, and digital content from nearly 200 publishers.