When you create a Cognos® report, you may need to provide the people who run the report the ability to filter the results, rather than selecting all the data in the application. Using
Cognos® Report Studio, you can create various filters.
IBM® Marketing Operations users frequently want filters that do the following.
As a best practice, use a Select & Search prompt to enable users to filter a report based on an object name or object code. The IBM® Marketing Operations data items use the naming scheme [PlanBV].[
<Object>].[
<item>]. (For example, the data item for project IDs is [PlanBV].[Project].[ProjectID].)
In order to create a date filter in Cognos® that returns any object that is active during a certain date range, exactly like Advanced Search in
IBM® Marketing Operations, use a date prompt with the range option enabled and create a filter that includes both the start date and the end date. This returns objects that meet any of the following criteria.