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 a variety of filters. Unica 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 Unica 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 Unica 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.
In order to prompt users for an object’s status and/or type do the following.
To prompt for status, use a a multi-select control using the <OBJECT> Status Query Subject.
IBM Unica Marketing Operations
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|