A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
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)
Oracle 11g Release 2 (11.2) for Microsoft Windows x64 (64-bit)
Oracle 11g R2 Client
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
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 interfaceInstalling 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 finishedInstalling 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
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
great Outdoors sales
great Outdoors retailers
great Outdoors sales Data ware House
Great Outdoors Market,
great Outdoors Human Resources
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
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
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"
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 fileImport 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 underRun the sample
IBM Cognos Business Intelligence Serverv10.1.1 and samples for Oracle installation Deployment "Go"
Start building with 50+ products and up to 12 months usage for Elastic Compute Service