1, ReportNet
Data Base Installation reportnet must have a repository (content Store) to store the relevant information. You can use databases such as ORACLE,DB2, SQL Server, and so on. ø recommends creating instances, tablespaces and users for the Cognos database. ø This library must be a Unicode character set. ø if Oracle is 8.1.7, the character set is UTF-8 and if Oracle is 9I, the character set is Al32utf8. ø If the content store is 9i, the Oracle client on the ReportNet server must also be 9i. ø If the database is DB2, you can see the following script to build the database in Server CRN 1. Type Db2cmd 2 in the run. If DB2 is not started, type DB2SATRT 3. Type DB2, press ENTER 4. Type CREATE database CRN using CodeSet UTF-8 TERRITORY CN COLLATE using SYSTEM creates a db named CRN. 5. Connect database Crn:connect to CRN 6. Execute the following three commands in turn to modify the configuration of CRN: update DATABASE configuration USING applheapsz DEFERRED; UPDATE the DATABASE CONFIGURATION USING LOCKTIMEOUT-DEFERRED; CREATE bufferpool TEMP IMMEDIATE SIZE PAGESIZE K 7. Create a directory DB2CRN on the e-drive, or modify the path in the statement. Execution: CREATE SYSTEM temporary tablespace CRNSYS PAGESIZE K MANAGED by SYSTEM USING (' e:/db2crn/crnsystmp2 ') extentsize 16 overhead 10.5 prefetchsize 16 Transferrate 0.14 Bufferpool TEMP Note that the direction of the diagonal bar after the E drive in the path cannot be reversed. 8. EXECUTE statement: CREATE USER temporary tablespace crnusr PAGESIZE 4 K MANAGED by SYSTEM USING (' e:/db2crn/crnusrtmp2 ') Extentsi ZE OVERHEAD 10.5 prefetchsize, transferrate 0.14 bufferpool IBMDEFAULTBP After the database is established. The connection to the database is established on the ReportNet server. Program--IBM db2--Setup Tool--Configuration Assistant--select--Use the wizard to add a database or configure it via ODBC.
Install ReportNet first put a disc labeled ReportNet 1.1 MR2 windows, Wait for the auto-run interface or manually run the CD-ROM in the directory Win32 under the Xwsetup.exe installer to enter the installation interface; Install according to the prompts (by default), install directory selection C:/cognos; put in a disc labeled ReportNet Supplementary Language simplified chiness (ZH) 1.1MR2, Wait for the auto-run interface or manually run the Xwsetup.exe program under directory Win32 in the disc, and select the same directory as the previous step to overwrite the installation; Install the ReportNet patch, install the method reference in the patch pack Readme.txt Configure ReportNet 1) Open the Cognos configuration in the ReportNet program group, right-click Data access->conent Manager, select New Resource->database,name Fill in CRN (219 for BK_CRN), type select DB2 database; in resource properties page; 2) Select Actions->edit Global Configuration ... in the top menu, add a ZH-CN to the Product Locales tab; 3) Right-click Security->authentication, select New Resource->namespace ..., Name fill in Ntlm,type select NTLM, OK; 4) Save and exit the Cognos Configuration. 5) See if there are Db2java.jar and c:/cognos/crn/webapps/p2pd/web-inf/lib under the Db2jcc.jar, if not, open C:/Program Files/ibm/sqllib/java, copy db2java.zip, Db2jcc.jar to C:/cognos/crn/webapps/p2pd/web-inf from /lib, and change Db2java.zip to Db2java.jar, delete database bk_crn and CRN related tables, views, triggers, repeat step (1), restart report Net 6 after completion) (depending on the project) to the report net configuration data source, click Tools/directory/data source, new data source, name: DW, click Next, type Select DB2, click Next, DB2 database name: DW , in the login user ID, password before tick, user ID, password, confirm password, fill in the test connection, to ensure that the connection is successful, click Finish after the test. Add data source Stat_ods in the same way (name STAT_ODS,DB2 database name stat_ods, user ID, password, confirm password)
Appache The default installation is Appache. Locate the conf/httpd.conf file in the Appache default installation directory and add the configuration of the virtual path at the end of the file. /* Establish CRN virtual path, point to Webconten subdirectory under the default installation directory of ReportNet, give permission to read, run scripts, browse. */ALIAS/CRN "c:/cognos/crn/webcontent/" <directory "c:/cognos/crn/webcontent" > Options Indexes multiviews allowoverride None Order allow,deny allow From all </Directory>/* Build crn/cgi-bin virtual path, point to Cgi-bin subdirectory under default installation directory of ReportNet, give read, run script, execute CGI program browse permission. */alias/crn/cgi-bin/"c:/cognos/crn/cgi-bin/" <directory "C:/cognos/crn/cgi-bin" > Options + execcgi AddHandler cgi-script. CGI allowoverride None Order allow,deny allow from Al L </Directory>/* Build crn/help virtual path, point to documentation subdirectory under ReportNet's default installation directory, give read, run script, browse permissions. */alias/crn/help/"c:/cognos/crn/webcontent/documentation/" <directory "c:/crn/cognos/crn/webcontent/ Documentation "> Options Indexes multiviews allowoverride None Order Allow,deny allow from all </Directory>
2, Powerplay and Transfomer
Installing Powerplay ServerInsert the disc labeled Cognos Powerplay Enterprise Server 7.3 Windows (EA), wait for the auto-run interface or manually run the Setup.exe program on the disc to install, option to choose Default; the installer prompts at the end of the Configure the server, choose to enter the Configuration Wizard program, configure it according to the prompts (the default setting), configure the configuration Manager after the end, select the root node, click the Apply Service button above, and after the configuration is complete, you can To start the service, you can see ppes corresponding service-cognos powerplay Enterprise Server (CER4) in the service of management tools
Installing transformerPut the disc labeled Cognos Powerplay user 7.3 for simple Chinaese, Wait for the Autorun interface or manually run the CD-ROM Setup.exe program to install, select the installation type to choose a custom installation, the Transfomer tick, the other by default installation.
Add Appache configuration /* Build Cognos virtual path, point to the WebContent subdirectory under the default installation directory of PowerPlayer Enterprise server, give permission to read, run scripts, browse. */Alias/cognos "C:/Program files/cognos/cer4/webcontent/" <directory "C:/Program files/cognos/cer4/webcontent" > Options Indexes multiviews allowoverride None Order Allow, Deny allow from the all </Directory> /* Build Cognos/cgi-bin virtual path, point to PowerPlayer Enterprise The Cgi-bin subdirectory under the default installation directory of the server grants read, run scripts, execute CGI programs, and browse permissions. */ alias/cognos/cgi-bin/"C:/Program files/cognos/cer4/cgi-bin/" <directory "C:/Program Files/cognos/cer4/ Cgi-bin "> Options +execcgi AddHandler cgi-script. CGI allowoverride None Order A Llow,deny allow from the all </Directory>/* Build cognos/help virtual path, point to PowerPlayer Enterprise The documentation subdirectory under the default installation directory of the server gives permissions to read, run scripts, and browse. */ alias/cognos/help/"C:/Program files/cognos/cer4/documentation/" <directory "C:/Program FILES/COGNos/cer4/documentation "> Options Indexes multiviews allowoverride None Order Allow,deny allow from all </Directory>
3, Decisionstream
Insert the disc labeled Cognos Decisionstream 7.1MR4, wait for the auto-run interface or manually run the Setup.exe program on the CD to install it, and in the registration details the input obtained The right code (ask the CD Manager), the following steps are installed by default;
