IBM Cognos Business Intelligence Serverv10.1.1 and samples for Oracle installation Deployment "Go"

Original: http://blog.csdn.net/esrichinacd/article/details/8433333

The previous article introduced the installation and deployment of the IBM Cognos business Intelligence Development, but the study found that ESRI Maps for Cognos could not be installed on the development version, That's why the installation and deployment of the Enterprise Edition have been re-organized.

Software deployment is divided into several steps installation media preparation

• IBM Cognos Business Intelligence Server v10.1.1 (32-bit)

• Ibm_cognos_business_intelligence_samples_10.1.0_for_oracle_windows_english

• Ibm_cognos Frameworkmanager

• Oracle 11g Release 2 (11.2) for Microsoft Windows x64 (64-bit)

• Oracle 11g R2 Client

Install Oracle 11g Release 2 (11.2) for Microsoft Windows x64 (64-bit)

This step is skipped directly, note that setting the character set to UTF-8 in installation options is installed.

Installing the Oracle 11g R2 Client

There's nothing to say. The default installation is to ensure that the client can connect to the database server after the database installation is complete.

NOTE: The Oracle database server and Cognos can be deployed separately, but the Cognos side needs to install the client corresponding to the Oracle version, and must be a 32-bit client and cannot install 64 bits.

Installing IBM Cognos businessintelligence Server v10.1.1 (32-bit)

Double-click Issetup.exe under the installation media directory, basically the next:

Click Finish to exit the installation process, you can start the IBM Cognos configuration directly, or you can start the IBM Cognos configuration from the Start menu.

Leave the default parameters to start the service directly, click the upper left corner of the start button

Error occurred

The reason is that the Content Manager database connection is not configured, here we select the Oracle database to configure, delete the original content Store, right-click Content Manager Select New Resource----database

Name to fill, type select Oracle Database

Click OK and enter the parameters for the Oracle database connection: server name, port number, user name, password, Oracle DB instance name, and so on.

Click OK and then right------The Oracle Test

If the above error occurs, Cognos cannot find the driver for the Oracle database. We need to install the Oracle database client that corresponds to the database server version, in the client directory ... \product\11.2.0\client_1\jdbc\ Under Lib, copy the Ojdbc5.jar and Ojdbc6.jar two files to the Cognos installation directory ... \ Ibm\cognos\c10\webapps\p2pd\web-inf\lib, reopen IBM on the Start menu Cognosconfiguration, save the file with UTF-8 first

Then the connection test, the result is:

Re-click the Start button in the upper left corner of IBM Cognosconfiguration to start the service

At this point, the Cognos service started successfully.

Note: If there is an error in this step, the click Details prompt is the Content Manager configuration problem, because the database configuration is not correct. It is emphasized here to configure the Content Manager database requirements: Create a user on the database server and give DBA authority to create their default tablespace. For example:

Create tablespace cognos datafile ' D:\app\yuyouxiang\oradata\orcl\cognos.dbf ' size 100M autoextend on;

Create user Cognos identified by Cognosdefault tablespace Cognos;

Grant connect,resource,dba to Cognos;

Installation lessons: Before starting the service, please configure the above database requirements, the Content store connection test can be successful but not guarantee the success of the service, because the service is started to the database to create a new n table.

Another: If the Cognos Contentdatabase is selected at the time of installation

The above database configuration is not required.

After the service starts successfully, enter Http://localhost:9300/p2pd/servlet/dispatch in the browser

For the first time into the Cognos Web interface, many of the styles in the Web page do not exist because we are using the Cognos-brought Tomcat to launch the Web application and need to C:\Program files\ibm\cognos\c10\ All content in the WebContent directory is copied to the C:\Program files\ibm\cognos\c10\webapps\p2pd directory, and then the browser address is refreshed, and the Cognos development interface can be fully displayed.

Finally finished, to a welcome interface

Installing the Ibm_cognos Framework Manager

The framework is used to develop a report model release package, and as a model developer, you only need to install the framework installer on your computer, configure the gateway information, and point directly to the Cognos Report server address. This allows the model developed on the framework to be published on the specified server.

Under the Installation media folder, select Win32----Issetup.

Then all the way next until finished

Installing IBM Cognos samples_10.1.1

The installation process is primarily to obtain the Oracle database backup files for samples data, and finally restore these backup files to the Oracle database.

Under the Installation media folder, select Win32

Run Issetup

All the way next until the installation is complete

Installation is complete. The sample locations installed are:

C:\Program Files (x86) \ibm\cognos\c10\webcontent\samples

The datasource\oracle of the path contains the DMP data file for the sample data, and the DMP data backup file is imported into Oracle in a later configuration.

Post install----sample data import and Cognos database connection and configuration example database recovery after installation

The data that needs to be imported includes

Database or Schema description	Oracle
CSTATD	cstatd. DMP
great Outdoors sales	gosales.dmp
great Outdoors retailers	gosalesrt.dmp
great Outdoors sales Data ware House	gosalesdw. DMP
Great Outdoors Market,	GOSALESMR. DMP
great Outdoors Human Resources	gosaleshr. DMP

CSTATD is located in C:\Program Files (x86) \ibm\cognos\c10\webcontent\samples\datasources\oracle

The remaining four DMP are located in the Data folder after Gs_db_ora.tar decompression

The following preparations are required before importing data:

· Create a database with the same name as DMP, size sensitive .

· to create a user with SELECT permission

· use UTF-8 encoding on the database server .

· Modify client environment variables, execute under Windows:set nls_lang=american_america.utf8

Log in to the database as an administrator and execute the following database scripts:

Create tablespace cstatd datafile ' D:\app\yuyouxiang\oradata\orcl\CSTATD.dbf ' size 50M autoextend on;

Create tablespace gosales datafile ' D:\app\yuyouxiang\oradata\orcl\GOSALES.dbf ' size 100M autoextend on;

Create tablespace gosalesrt datafile ' D:\app\yuyouxiang\oradata\orcl\GOSALESRT.dbf ' size 5M autoextend on;

Create tablespace gosalesdw datafile ' D:\app\yuyouxiang\oradata\orcl\GOSALESDW.dbf ' size 200M autoextend on;

Create tablespace gosalesmr datafile ' D:\app\yuyouxiang\oradata\orcl\GOSALESMR.dbf ' size 25M autoextend on;

Create tablespace gosaleshr datafile ' D:\app\yuyouxiang\oradata\orcl\GOSALESHR.dbf ' size 25M autoextend on;

Create user cstatd identified by Cstatddefault tablespace cstatd;

Grant CONNECT,RESOURCE,DBA to CSTATD;

Create user gosales identified by Gosalesdefault tablespace Gosales;

Grant CONNECT,RESOURCE,DBA to Gosales;

Create user gosalesrt identified bygosalesrt default tablespace gosalesrt;

Grant CONNECT,RESOURCE,DBA to GOSALESRT;

Create user Gosalesdw identified bygosalesdw default tablespace gosalesdw;

Grant CONNECT,RESOURCE,DBA to Gosalesdw;

Create user GOSALESMR identified BYGOSALESMR default tablespace GOSALESMR;

Grant CONNECT,RESOURCE,DBA to GOSALESMR;

Create user gosaleshr identified bygosaleshr default tablespace gosaleshr;

Grant CONNECT,RESOURCE,DBA to Gosaleshr;

Open cmd to perform the import of the database:

Imp cstatd/[email protected]=d:\dmp\cstatd.dmp log=d:\imp_cstatd.log full=y

Imp gosales/[email protected]=d:\dmp\gosales.dmp log=d:\imp_gosales.log full=y

Imp gosalesrt/[email protected]=d:\dmp\gosalesrt.dmp log=d:\imp_gosalesrt.log full=y

Imp gosalesdw/[email protected]=d:\dmp\gosalesdw.dmp log=d:\imp_gosalesdw.log full=y

Imp gosalesmr/[email protected]=d:\dmp\gosalesmr.dmp log=d:\imp_gosalesmr.log full=y

Imp gosaleshr/[email protected]=d:\dmp\gosaleshr.dmp log=d:\imp_gosaleshr.log full=y

Execute the Gs_or_modify.sql script, adjust the relationship between users, located in the Data folder after Gs_db_ora.tar decompression

At this point, the sample data import is complete.

Create a data source connection for the sample database

Open BM Cognos Administration

Select configuration

upper right corner click New Data source

Fill in the name Great_outdoors_sales, next select the data source type, Oracle

Fill in the Oracle DB instance name and user name and password (gosales) and click Test Connection

The test was successful.

This data source Great_outdoors_sales is created successfully, repeat the above operation to establish a database connection named Great_outdoors_warehouse, the data source select "Gosalesdw"

To create a cube data source

Input Sales_and_marketing_zh

Data source Select IBM Cognos PowerCube

In the New Data Source Wizard, the Windows location input

C:\ProgramFiles (x86) \ibm\cognos\c10\webcontent\samples\datasources\cubes\powercubes\zh\sales_and_marketing_ Zh.mdc

Then click "Test"

Test success

Click Done.

Repeat the above steps to create the other 5 data sources, MDC under the same folder.

Import Sample Content

\ibm\cognos\c10\webcontent\samples\content location in C:\Program Files (x86) contains our sample content

Here we only import Ibm_cognos_samples.zip, Ibm_cognos_powercube.zip

First copy it to C:\Program Files (x86) \ibm\cognos\c10\deployment

In the upper-right corner of configuration---Content management, select New Import

Choose one of them, such as Ibm_cognos_samples

"Next" to complete and run.

At this point, we have completed the import of Ibm_cognos_samples.zip.

You can import Ibm_cognos_powercube.zip backups in the same way.

View the imported report file

Import Pictures

The reports developed in simple are used in other images and need to be

Copy the \ibm\cognos\c10\webcontent\samples\images folder to

\ibm\cognos\c10\webapps\p2pd\samples under

Run the sample

IBM Cognos Business Intelligence Serverv10.1.1 and samples for Oracle installation Deployment "Go"