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.

580 views0 comments

Recent Posts

See All

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

Cognos 11.1.6 is finally available!

Cognos Analytics 11.1.6 is finally available for general download and as a release, it has a lot of great features. My friend, Ryan, at IBM BlueView sums up the new features perfectly so I'm going to