Chapter 6. Reporting with IBM Cognos Business Intelligence 169
creation and publishing of reporting packages. These reporting packages enable users to be
able to quickly locate, access, and report on data.
When creating your metadata model, it is best to understand the reporting requirements of
your business. The greater number of requirements you can cover in a model, the less
maintenance your model will require over time, which can save you time and money over the
long run. Before you make a model available to your user community, be sure that it is
complete per the user requirements. If a model must be published early, before it is final, you
will want to leverage the IBM Cognos Business Intelligence model versioning capabilities.
These capabilities will help you to keep track of all the versions of your model so you can
reconcile them when your model is final.
6.2 Creating data source connections
The warranty sample makes use of the new dynamic query mode to enable query
optimizations to our IBM DB2 Universal Database via a single connection definition. This
connection is defined using the IBM Cognos Administration interface, without the need for any
thick client installation.
To create the data source connections you need to:
򐂰 Configure IBM DB2 connectivity
򐂰 Create the connection to the warranty claims database
6.2.1 Configure IBM DB2 connectivity
To enable the reporting engine to connect to IBM DB2, or another relational DB, you only
need to copy the Java Database Connectivity (JDBC) driver files to the IBM Cognos
installation directory.
To configure IBM Cognos Business Intelligence with the IBM DB2 JDBC drivers:
1. Locate and copy the installed db2jcc4.jar and db2jcc_license_cu.jar files from the
../sqllib/java directory on your IBM DB2 server.
2. Next, locate the ../v5dataserver and webapps ../p2pd/web-inf/lib directories on the
IBM Cognos Business Intelligence servers with the Report Server component installed,
and paste in both the db2jcc4.jar and db2jcc_license_cu.jar files.
3. Restart each IBM Cognos Business Intelligence server where the files were copied.
6.2.2 Create the connection to the warranty claims database
The data in the warranty claims database allows you to create reports detailing customer
warranty claims. These reports can help business users assess the need for making
adjustments to their processes, products or businesses.
Note: To learn more about setting up the dynamic query mode, go here:
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/topic/com.ibm.swg.ba.cogno
s.dyn_query.10.1.0.1.doc/c_dyn_query_setup.html#dyn_query_setup
Before you begin: IBM Cognos Administration is part of the Cognos web interface and
can be accessed from IBM Cognos Connection using the Launch menu.
170 Implementing an Advanced Application Using Processes, Rules, Events, and Reports
To create the connection to the warranty claims database via the Cognos Administration
interface:
1. Click the Configuration tab followed by the New Data Source icon (Figure 6-1) to start
the New Data Source wizard.
Figure 6-1 New data source
2. Enter the following information in the New Data Source window (Figure 6-2) and click Next
when done:
Name Warranty claims database
Description Warranty claims database records all incoming requests
Screen tip Warranty program database
Figure 6-2 New Data Source wizard: Specify a name and description
3. In the Specify the connection dialog that opens, select Type IBM DB2, and check the
Configure JDBC connection checkbox as shown in Figure 6-3 on page 171.
Chapter 6. Reporting with IBM Cognos Business Intelligence 171
Figure 6-3 Selecting the data source type
4. Click Next to open the Specify the IBM DB2 connection string dialog (Figure 6-4 on
page 172) and complete the following steps:
a. Enter Warranty claims in the DB2 database name field.
b. Check the Open asynchronously checkbox.
c. Select the Signons radio button.
d. Select Password, and then enter the user ID and password provided by your database
administrator.
e. Click Next when done.
172 Implementing an Advanced Application Using Processes, Rules, Events, and Reports
Figure 6-4 Specifying the connection string to IBM DB2
Important testing note: You do not test the connection now because you have not yet
configured Cognos to use the thick client interface for IBM DB2 and your test will
generate errors. Further, a test at this point is not applicable for the Dynamic Query
Mode capability you are configuring.
Chapter 6. Reporting with IBM Cognos Business Intelligence 173
5. In the Specify the IBM DB2 (JDBC) connection string dialog (Figure 6-5):
a. Enter the server name or IP address for your DB2 server in the Server name field.
b. Change the value to match your server’s port number in the Port number field.
c. Enter the database name as it is defined on the IBM DB2 Server in the Database name
field.
Figure 6-5 Specify the IBM DB2 JDBC connection string

Get Implementing an Advanced Application Using Processes, Rules, Events, and Reports now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.