INSTALLATION OF IBM COGNOS 8.4.1 (Part-5)

Configuration of Projects in Framework Manager:


Open Framework Manager. (It can be found in the Start menu, under All Programs, IBM Cognos 8 BI Developer Edition. Choose Framework Manager.)
Open the project file C:\Program Files \IBM\CognosDeveloper841\webcontent\samples\models\great_outdoors_sales\great_outdoors_sales.cpf
Step-1: Expand Data Sources and for each data source check that the 'Content Manager Datasource' and 'Schema' have the same value (gosales, gosalesdw, gosalesrt, gosaleshr).
Step-2: Modify the Interface (Type) to "OR" instead of "OL".
Step-3: Test each of the Datasources. If it fails, try restarting the Oracle database. Save your changes to the project file. 
Step-4: Expand Packages and publish each package. To do this, right click on the package name and publish the package.)
Step-5: Try to ignore the errors, if any, at this stage. Save and Exit.


Open the project file C:\Program Files \IBM\CognosDeveloper841\webcontent\samples\models\great_outdoors_warehouse\great_outdoors_warehouse.cpf
Follow the above steps for this project file too.

INSTALLATION OF IBM COGNOS 8.4.1 (Part-4)

Creating Data Sources:
Click the "New Data Source" button.
How do we create a new data source for the sample oracle database?
Start by typing "gosales" for name of the data source and then click the Next button. Choose "Oracle" as the Type and click the Next button. The Connection String is "xe". Enable UserID and Password Checkboxes. The UserID is "gosales" and type the corresponding password as before.
Test the connection. It should be successful. If not, try to restart the Oracle database.
Once the connection is tested successfully, click the Finish button.


Repeat the above mentioned steps for "gosalesrt", "gosalesmr", "gosaleshr" and "gosalesdw".

INSTALLATION OF IBM COGNOS 8.4.1 (Part-3)

Import the Database Files:
The next step is to unzip the files related to database and import them.
Go to C:\Program Files\IBM\Cognos\webcontent\samples\datasources\oracle.
We can find the files with the extension ".dmp". Unzip each one of them. And hence the Crash Dump Files are created. We will be importing each of the following files.
Now execute the following command in the command prompt.
First change the directory in the command prompt to:
C:\Program Files\IBM\CognosDeveloper841\webcontent\samples\datasources\oracle.
Run the following commands step-by-step. After executing each of these commands, make sure to check the log files.


imp gosales/cognos@xe file = GOSALES.dmp log = log_gosales.txt
imp gosaleshr/cognos@xe file = GOSALESHR.dmp log = log_gosaleshr.txt
imp gosalesdw/cognos@xe file = GOSALESDW.dmp log = log_gosalesdw.txt
imp gosalesmr/cognos@xe file = GOSALESMR.dmp log = log_gosalesmr.txt
imp gosalesrt/cognos@xe file = GOSALESRT.dmp log = log_gosalesrt.txt


Hope you remember that gosales, gosaleshr, gosalesdw, gosalesmr, gosalesrt are the users we have already created in Oracle. We have pretty much done all the data import into our Oracle database.


Creating the Data Sources:
Open Start -> IBM Cognos 8 BI Developer Edition -> IBM Cognos 8 BI Developer Edition. Now Launch IBM Cognos Administration. Open the "Configuration" Tab -> Data Source Connections.

INSTALLATION OF IBM COGNOS 8.4.1 (Part-2)

Once the installation of Cognos and samples is ready, we can proceed to the next step, that is creating the users in Oracle.

Creating Users in Oracle:

(1) Click Start -> Programs -> Oracle Database 10g Express Edition -> Go To Database Home Page.

(2) Enter the Database User name as "SYSTEM" and the password.

(3) In the following the command area, type the following commands one by one and click on "Run". 

create user cognos identified by cognos;

create user gosales identified by cognos;

create user gosalesdw identified by cognos;

create user gosaleshr identified by cognos;

create user gosalesrt identified by cognos;

create user gosalesmr identified by cognos;

grant dba to cognos;

grant dba to gosales;

grant dba to gosalesdw;

grant dba to gosaleshr;

grant dba to gosalesrt;

grant dba to gosalesmr;

Note: In the above command, "user" means the schema, and "identified by" means the password.

INSTALLATION OF IBM COGNOS 8.4.1 (Part-1)

Version: Cognos 8.4.1

Cognos Overview: Reports, analysis, scorecards, dashboards, alerts, and ETL from a single, services-based architecture

Operating System: Windows XP Professional

Installers Required:

1. IBM Cognos 8 BI Developer Edition 8.4.1 Windows English

2. IBM Cognos 8 BI Developer Edition Oracle Samples 8.4.1 Windows English

3. OracleXEUniv.exe  (Oracle Database 10g Express Edition (Universal))

Links/Screen-shots related to downloading the installers:

Open www.ibm.com in Internet Explorer.

Click on "Trials and Demos". 

Choose "Cognos 8 Business Intelligence".

A trial version is sufficient to learn Cognos. It is available for download from the following links.

Click on the link "Register". Register using your email id and a password. Accept the License Agreement. Click "Submit".

Download the above two zip files. Unzip it. 

You can find them in the following location, in common:

C:\Documents and Settings\Administrator\DownloadDirector\CZH9IEN.tar.gz

C:\Documents and Settings\Administrator\DownloadDirector\CZH9KEN.tar.gz

Now the installers are ready for Cognos and Sample Reports.

Then the next step is to install Oracle Express Edition:

Open the link oracle.com in Internet Explorer. You can register your email id with Oracle website. Sign-in and proceed with the following steps:

One can find the intaller in the following path, in common:

Destination Folder: C:\oraclexe\

Port for 'Oracle Database Listener': 1521

Port for 'Oracle Services for Microsoft Transaction Server': 2030

Port for HTTP Listener: 8080

Username: SYSTEM

Now you are ready with the softwares.


Double click on the executable files "install" and "install_ORA_samples" present in CZH9IEN and CZH9KEN folders respectively.

Click "Next". Select the Radio button "I Accept" and click on "next". Select the location to install Cognos.

Ignore warnings, if any. Click "Next". Click "Next" when asked for components. The shortcut folder can be the default settings. Click "Next". Installation summary is shown. Click "Next". You can see the progressing installation. Installation should complete successfully.

Similarly, for Cognos BI Samples, keep clicking "Next" until "Finish".

Congrats!!! Now you have installed successfully!!!