Tips and Tricks: Add a Select and Search Prompt to a Report that uses a Data Module

One of the missing features with Data Modules is the ability to use a Select & Search (search and select?) prompt in Cognos reports.


Not sure why that is not supported yet but it is on the list of "maybe someday".


Reporting limitations when using data modulesThe following limitations apply when data modules are used as sources in Cognos Analytics Reporting: Data modules and Framework Manager packages cannot be combined in the same report. In IBM Cognos Analytics 11.1.7 and earlier versions, only one data module can be used as a source for a report. Starting with Cognos Analytics 11.1.7 FP1, multiple data modules can be used as sources for one report. Data modules that are based on dimensional data sources, such as PowerCubes, dynamic cubes, TM1 data sources, and dimensionally-modeled relational (DMR) data sources, are not supported. The Build prompt page tool, and the Select & search prompt and Tree prompt prompt types are not available in reports.

(See the whole list here).


So, I found a work-around for this. It's not pretty but it works.


If you want to add a Select and Search prompt to your report, create a new Cognos report. Do not add a package. Add a prompt page and add a Select and Search prompt to the display. Hit Finish to continue - you don't have to do any of the settings.




Copy the prompt object to your real report. You can now set it up using the property sheet.



704 views0 comments

Recent Posts

See All

How to upgrade Cognos Analytics

Had a chance to join the amazing Ryan Dolley today on a livestream detailing how to upgrade Cognos Analytics like a pro. https://www.youtube.com/watch?v=EqZHDIdrC-0 Upgrades are one of the things I do

Join Optimization

Here's a blog post I wrote for our company blog on join optimization in data modules. This concept is particularly useful if you are joining two different data sources in a data module. https://pmsqua