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
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:
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.