Question & Answer
Question
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.
Cause
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.
Answer
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.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21637038