Monday, January 28, 2013

Basic Installation and Configuration of Cognos:


Installation and Configuration of Cognos 8.4 with DB2 and Apache web server2.0:


Db2:
 
  • Install DB2
  • Create a database with UTF-8 code set and named as content store.
  • Create two buffer pool with 32kb and 4kb space.
  • Create regular,System and User temporary table spaces with 32kb page size for system,user, regular and point out 32kb buffer pool.
  • Create system temporary table space with 4kb page size and point out 4kb buffer pool.

Cognos:

  • Install Cognos
  • Copy Common.jar,db2jcc4.jar,db2jcc.jar,db2dbgm.jar,db2java.zip,db2qgjava.jar files from DB2Installation path\IBM\SQLLIB\Java and put it under C:\Program Files\cognos\c8\webapps\p2pd\WEB-INF\lib
  • Launch Cognos Configuration.
  • Delete default content store,create new one and configure the content store by giving content store database name, port number, location of content store with cognos.
  • Save the configuration.

Apache web server:

  • Install Apache web server
  • Add the below script
ScriptAlias /cognos8/cgi-bin "C:/Program Files/cognos/c8/cgi-bin/"
 <Directory "C:/Program Files/cognos/c8/cgi-bin">
     Options Indexes MultiViews
     AllowOverride None
     Order allow,deny
     Allow from all
 </Directory>
Alias /cognos8 "C:/Program Files/cognos/c8/webcontent"
 <Directory "C:/Program Files/cognos/c8/webcontent">
     Options Indexes MultiViews FollowSymLinks
     AllowOverride None
     Order allow,deny
     Allow from all
 </Directory>
in httpd.conf file present within the folder:Apache HTTP Server 2.0\data\usr\local\Apache2\conf

Start services:

Start content store database.
Start cognos server
Start apache server

2 comments:

Karthikeyan C said...

What is meant by "Impacted Report" and "Data Lineage"? How to find the impacted report and data lineage in report studio?

Nanno Blankestijn said...

The impact report can be found in Framework Manager > Right click on the Package and choose "Analyse Publish Impact..."

Data Lineage can be found in report Studio when you right click on a insertable object.

See also: http://howtocognos.com/cognos-components/lineage/