Database Reference
In-Depth Information
Search technology has become sophisticated enough that documents can be searched for
text and the phrases can be highlighted to allow the searcher to focus on the text. The analyst
would like to simulate that functionality in the report.
This report should be able to prompt the user for a search phrase and return a list of product
descriptions that contain the phrase and highlight the selected text. The final result should look
like Figure 1.1.
Figure 1.1
Completed enhanced product catalog
The trick to solving this problem is to utilize several string functions that are available in IBM
Cognos Report Studio in order to find the requested part of the text and then cut the preceding and
succeeding text. Once the searched text field has been separated into three parts, we can use the
logic within our query items to put the strings back together within a single column and highlight
only the searched text.
The list report should filter on only those products that contain the search text.
The key steps involve the creation of a query that parses the product description and removes any
products that do not have the matching phrase. With the query built and tested, the list report is
designed.
Step 1: Start the Report
1.
Launch
Report Studio
and select the
GO Data Warehouse (query)
package.
2.
Click on the
Create new
option.
COGNOS 8 NOTE
The option is
Create a new report or template
.
