Cognos 10 Framework Manager新手上路

好久没来，都忘记上次写文章是什么时候了...

关于Cognos Framework Manager我也是新手，花了一周时间按照sample做了一遍。写了这边文章作为我的学习笔记。

大部分内容我是copy handbook里面的，稍微做了点简化。我觉得最有价值的是前面的configuration和后面的部分，但是文章内容太长，太多截屏，这里不发了。免费下载地址如下：

HandBook 下载地址： http://download.csdn.net/detail/zzphapy/3871694
这篇文档下载地址： http://download.csdn.net/detail/zzphapy/3871717
 

这里只发前半部分新手做配置的时候常常遇到的问题。如果没做足下面的配置，你可能遇到一下错误：

QE-DEF-0368

QE-DEF-0285

QE-DEF-0325

RQP-DEF-0068

1.Install and configure

1)Install Cognos FM step by step

If you are installing FM client on the Cognos server, you can install FMby default steps.

If you are using this FM client connect to otherserver, please don't install FM client to the folder where the server installed.

 

2)Install Oracle Client

Make sure you have oracle clientinstalled on the Cognos FM client that has the datasource entry.

 

3)Configure TNS file

The tnsnames.ora file must have the correct configuration forthe Oracle server that you are trying to connect to. Setup TNS in your OracleClient like below:

Orcl=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST =xxx.xxx.xxx.xxx)(PORT = 1521))

    (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME =XXX)

    )

  )

 

4)Copy Oracle JAR file to FM client

Copy C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc5.jarand paste to C:\Program Files\IBM\cognos\FM\webapps\p2pd\WEB-INF\lib

 

5)Copy CSK folder from Cognosserver to FM client

Copythe folder configuration/csk from the Cognos server and paste to the same pathin FM client.

 

6)Open Configuration and set theEnvironment

Change the "Gateway URI" and "Dispatcher URI……" path to your own server address;

 

7)Save your changes

Click the Save button on the toolbar. Ignore the Certificate error.