O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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] ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required