IBM Support

How to use a Search & Select prompt against a DMR package.

Technote (FAQ)


This document describes how a Report Author can create Select & Search prompt to provide users ability filter a report on any member or group of members from within a hierarchy.


A business user wants a report that access a Dimensionally Modeled Relational (DMR) or OLAP over Relational. The report needs to contain a prompt that will allow the user to select any member or group of members from a hierarchy. A Tree prompt would normally be suitable for this type of situation, however the hierarchy contains many members and requiring the user to remember where each member is located in the tree is not reasonable. In this case, the user would like to use a Select & Search prompt.


For the Prompt Query, create the following data items
Display_Value with the expression roleValue('_memberCaption',members([Sales (analysis)].[Products].[Products]))
Use_Value with the expression roleValue('_memberUniqueName',members([Sales (analysis)].[Products].[Products]))

Add a slicer to the Report Query with the expression set(#promptMany('SearchAndSelect','MUN','[Products]')#)

Attached is a sample report that uses the IBM Cognos Samples.

Document information

More support for: Cognos Business Intelligence
Report Studio

Software version: 10.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1637038

Modified date: 12 September 2014

Translate this page: