
Set up the Java™ Runtime Environment, create an Oracle Listener and Net Service,
configure Oracle as the Cognos® content store, configure the
IBM® WebSphere® Application Server instance to host
the report server, build and deploy the enterprise archive files,
install the enterprise archive files, and create the data warehouses.
About this task
To configure the report server:
Note: Step 1 and steps 5 to
11 are not needed if you chose the automatic installation method for
installing the report server.
Procedure
- Create a content store database.
Note: Ensure
that you, as the current user, have the necessary administrative privileges
to create databases and table space containers. The current user is
the one that can connect at run time to the Cognos content store. If you want other users
to connect at run time to the Cognos content store, see the IBM Cognos 8 Business
Intelligence Installation and Configuration Guide for instructions.
- Login as an Oracle DBA user.
- If you have an existing content store from a previous
installation, delete it.
- Go to the /opt/IBM/RCPR/reportal/contentstore directory.
- Switch to the root user by running the su command. If prompted, type the root password.
- Set the permissions for the files and folders by running
the following command:
chown oinstall.oinstall /opt/IBM/RCPR/reportal/contentstore -R
- Return to the database administrator console and run
the install.sh shell script through the following
command:
[oinstall@VEGAVM contentstore]$ ./install.sh
- When prompted, specify the parameters for the content
store. To see a list of parameters and their explanations, see the
related links at the bottom of this page.
- Create the listener.
- Set the system variable ORACLE_SID=$SID, where $SID is the database
you created in step 1.
- Start Oracle Net Manager.
- Expand the nodes and select Listeners. Click .
- Enter the listener name and click OK.
- Click Add Address and specify
the host and the port for Rational® Common Reporting Data Service.
- Click Add Database, enter the
database name, home directory and SID, and click .
- Start the listener through the following command.
lsnrctl start
- Create the service name.
- Start Oracle Net Configuration Assistant.
- Select the Local Net Service Name configuration and click Next.
- Select Add and click Next.
- Enter the service name and click Next.
- Select a protocol and click Next.
- Enter the host name and port. Select Yes,
perform a test, click Next, change
the logon if necessary, make sure the connection passes the test.
- Enter the net service name and click Next.
- To avoid problems with encryption, set up the Java Runtime Environment (JRE) so that Cognos and the report server
run on the same JRE instance.
Note: This step is not needed
if you chose the automatic installation method for installing the
report server.
- Set the JAVA_HOME variable to point to the WebSphere Application Server JRE folder and
add %JAVA_HOME%\bin at the beginning of the system path:
JAVA_HOME=[WASDIR]\java\jre
PATH=%JAVA_HOME%\bin;…
- Copy the [Rational_Common_Reporting_installation_directory]/cognos/bin/jre/1.5.0/lib/ext/bcprov-jdk14-134.jar file to the [websphere_installation_directory]/java/jre/lib/ext directory.
- Ensure that the appropriate Oracle drivers is installed
in the [Rational_Common_Reporting_installation_directory]/cognos/webapps/p2pd/WEB-INF/lib directory:
- Oracle 10g: ojdbc14.jar
- Oracle 11g: ojdbc5.jar
- Delete the Tomcat-based IBM Cognos 8 service.
Note: This step is not needed if you chose the automatic installation
method for installing the report server.
- Start the Cognos administration console (run cogconfig.sh under /opt/IBM/RCPR/cognos/bin).
- Right-click the IBM Cognos 8 node, select Delete, and click Yes.
- Click Save, and click Close.
- Create a new content store in Cognos to reference the content database.
Note: This step is not needed if you chose the automatic installation
method for installing the report server.
- Start the Cognos administration console (run cogconfig.sh under /opt/IBM/RCPR/cognos/bin).
- Click , right-click Content Store, and click .
- In the Database name field, enter
the name of the database created in step 1.
- Select the User ID and password row, click the Edit icon, and enter a user name and password that
can be used to access the database content store created at step 1.
- Select Local Configuration, and
click Save configuration.
- Create a new WebSphere Application Server instance to host the report server. This step is not needed
if you installed WebSphere Application Server through the Rational Common Reporting installer.
- If you have changed the Cognos configuration, restart WebSphere Application Server.
Note: This step is not needed if you chose the automatic installation method
for installing the report server.
- Configure the WebSphere Application Server instance to host the report server.
Note: This
step is not needed if you chose the automatic installation method
for installing the report server.
- Open the WebSphere Application Server administrative console (open a browser to point to http://localhost:9060/ibm/console/).
- Replace port 9060 with another port number if it differs
from what you recorded from the WebSphere Application Server Profile Management
tool.
- Log on to the WebSphere Application Server administrative
console (point the browser to http://localhost:portnumber/ibm/console/login.do, and enter your user name and password).
- Expand the Servers node on the
left sidebar, and select Application servers.
- Click the server1 link, and expand
the Java and Process Management node.
- Click the Process Definition link,
and click the Java Virtual Machine link.
- Enter the initial and maximum JVM heap size as 256 and 768.
- Click Apply (at the bottom of
the page), and click the Save link.
- Click the Environment Entries link.
- Click New, and add the following
property:
LD_LIBRARY_PATH=[INSTALLDIR]\cognos\bin
- Click OK, click New, and add the following property:
PATH=[INSTALLDIR]\cognos\bin
- Click Apply, and click Save.
- Install the report server enterprise archive file.
Note: This step is not needed if you chose the automatic installation
method for installing the report server.
- Log on to the WebSphere Application Server administrative
console (point the browser to http://localhost:port/ibm/console/login.do, and enter your user name and password).
- Expand the Applications node
on the left sidebar, and select Install New Application.
- Click Browse, go to the [Rational_Common_Reporting_installation_directory]\cognos folder, and select the
p2pd.ear file.
- Accept the default options and click Next. Do this step four times.
- Click the Save link, click Enterprise Applications in the left sidebar, and if the
Default Application is listed, uninstall it.
- Select the IBM Cognos 8 application,
and click Start. The application takes a few
minutes to load fully and to start.
- Open a browser and point it to http://server:port/insight/servlet. If Cognos Content Manager
is working correctly, you see something similar to the following text
on the Web page:
IBM Cognos 8
Content Manager
Build: 8.4.2519.0
Start time: Tuesday, November 18, 2008 3:00:41 PM PST
Current time: Tuesday, November 18, 2008 3:01:25 PM PST
State: Running.
- Point the Web browser to http://host:port/insight. You
should see the home page of the Rational Common Reporting portal.
- Import the Rational Common Reporting sample reports.
Note: This step is not needed
if you chose the automatic installation method for installing the
report server.
- Copy the [Rational_Common_Reporting_installation_directory]/reportal/deployment/Rational_Example_Reports.zip file to the [Rational_Common_Reporting_installation_directory]/cognos/deployment/ directory.
- Open the Cognos Web application at http://host/cognos8/cgi-bin/cognos.cgi.
- Open the Cognos administration page ().
- Click Configuration.
- Click Content Administration,
click the New Import icon.
- Ensure that your product archive is listed as a deployment
archive, and click Next.
- In the Name field, change the name from Rational_Example_Reports to Rational_Reports, and click Next.
- To import all packages and folders, select the box in
the table header, and click Next four times.
- Click Finish.
- Click Run.
- Click OK.
- Click the Home icon.
- Verify that all packages and folders are listed in Public Folders.
- Test the Cognos data source connections for the data warehouse and the supported
products.
- Start the WebSphere Application Server administrative console. The default URL is http://localhost:9060/ibm/console/login.do.
- Open the Cognos administration page (click or
if you are at the Custom Reporting page, click the Administration
link in the banner).
- Click .
- Click the Set properties action
for the RIDW data source.
- Click the Connection tab.
- Click Test the connection.
- Click Test.
- Click Close twice, and then click OK.
- Click .
Note: To return to the list of data source connections, you might need
to click Cognos above the Name field.
- Click the Set properties action
for the product data source; for example, ClearQuest.
- Click the Connection tab.
- Click Test the connection.
- Click Test.
- Click Close twice, and then click OK.
- Test-run the Rational Common Reporting sample reports.
- Open the Cognos Web application at http://server:port/insight.
- Click the your product folder.
- Run the reports.
- Create a user for accessing the data source.
- Open the Cognos administration page (Click IBM Cognos Administration or
if you are at the default home page of IBM Cognos, click ).
- Click .
- Click RIDW.
- Click New Signon, enter a name,
and click Next.
- Enter the user ID and password to access the data source.
To run reports, a user should have at least read privileges to the
data source.