【原创】Cognos安装Sample及遇到相应问题

Cognos安装自带的Sample

I. Restore Databases.
Open a command prompt at C:Cognoscrnwebcontentsamplesdboracle, where you will see four .dmp files.
then import the gosales database to oracle by the command (imp gosales/gosales@orcl file = GOSL.DMP full=y).
Then it will import all the files.After this revoke dba from gosales by the command(revoke dba from gosales).
In the same way, import goretailers and the rest.

其中gosales/gosales@orcl 分别就是导入表的用户和相应的数据库实例
这里注意 查询了一些资料，大家都说，对执行的每个脚本都相应的用一个用户来导入
如：
imp gosalesdw/gosalesdw@orcl full=y file=GOSALESDW.dmp ignore=y;
imp gosaleshr/gosaleshr@orcl full=y file=GOSALESHR.dmp ignore=y;
imp gosalesrt/gosalesrt@orcl full=y file=GOSALESRT.dmp ignore=y;
imp gosalesmr/gosalesmr@orcl full=y file=GOSALESMR.dmp ignore=y;
imp gosales/gosales@orcl full=y file=GOSALES.dmp ignore=y;

这里需要注意一下导入文件的顺序，否则会出现约束问题
就是这个意思

成功导入表之后我们要做的
II. Define Data Sources.
In Cognos Connection (http://Localhost/cognos8) select Directory, Data Sources, New Data Source (icon).
Set up the four sample databases using the names gosales, goretailers, etc. The Framework Manager model expects these names.
The Oracle connection string should be the same as the service name in tnsnames.ora on the server (eg. orcl)
Use the different userids/passwords for each (eg. gosales/gosales), as set up in Oracle.
You can leave the collation sequence blank (but make sure you select the password checkbox).
Test the connections as you set them up.
在上面步骤 导入数据源时遇到了个问题，研究了好长时间
因为我用的是Oracle11g  11.2  64bit 版本的，遇到了个问题，在使用Cognos Connection时候，新建数据源
却会连接失败，提示

UDA-SQL-0432 Unable to locate the gateway "cogudaor".

这里我们要注意，Cognos Configuration 里头的  Security---Cognos Application FireWall里头的Enable CAF Validation 要是true

SQL*Net connect string:  填写的是数据库实例名字

重要的一点  64为bit 本来是不被Cognos 32bit支持的，64bit的没有试过
我们要安装Oracle的instant Client 并且配置相应的环境变量 具体最小需要哪些我去尝试，按照网上找的资料
我配置了
ORACLE_INSTANT_CLIENT  == O:OracleClientinstantclient_11_2
ORACLE_HOME == O:Oracle11gLiYunpengproduct11.2.0dbhome_1
TNS_ADMIN == %ORACLE_HOME%NETWORKADMIN
ORACLE_SID  ==   STUDY
PATCH 添加 %ORACLE_INSTANT_CLIENT
LD_LIBRARY_PATH == %ORACLE_HOME%LIB

还要把
O:Oracle11gLiYunpengproduct11.2.0dbhome_1NETWORKADMIN
中的sqlnet.ora和tnsnames.ora连个文件拷到instant Client的home目录里头

这样配置就OK了，创建了新的数据源
我们就可以在FrameWork里头导入这个数据源和相应的数据库了


我导入了两个数据源，分别名为
great_outdoors_warehouse
great_outdoors_sales
他们相对应导入的数据库是gosalesdw和gosales

III. Publish Framework Manager Package.
Open Framework Manager. Click Open a project... to create it the first time and go to the location
C:Program Filescognosc8webcontentsamplesModelsgosales_goretailersgosales_goretailers.cpf. and then select
data source and type it in the schema.
Simple给我们提供了一个Project 我们可以直接打开，也可以使用我们自己创建的Project



IV. Import Sample Reports.
Now we have databases defined, a connection to them from ReportNet, and the metadata model published.
All we need now is the sample reports to run. Copy Cognos_Samples.zip from crnwebcontentsamplescontent to crndeployment
In Cognos Connection, select Home (if you’re not already there), ToolsContent AdministrationImport tab, New Import (icon).
Cognos_Samples should appear in the list. Select Next, then Next again.
On the ‘Select the Public Folders Content’ page, select the checkbox to the left of the Cognos_Samples package.
Select Next, Next again, then Import Now.

这里我们需要注意的是他的位置 实际是在配置标签---管理内容 里面，我们在右面可以找到new import，就会看到刚刚复制过的zip可以导入了

V. Test Sample Reports.
Select Home (if you’re not there already), Public Folders, GO Sales and Retailers, Report Studio Report Samples,
and select a report (GO Media is a good one to try). It might take a few seconds to run the first report as everything
fires up. Run some more reports and queries to check that everything is working, and see what’s available to you.
ReportNet is now up and running.

现在我们可以对Sample进行试用了！