cognos安装流程

1、安装Cognos10 BI Sample

2、为样例数据库创建表空间

SQL> create tablespace tbs_cogsamp datafile

'/app/orabase/oradata/zzhdb/data02.dbf' size 500M autoextend off;

3、创建相关用户

SQL> create user gosales identified by cognos default tablespace

tbs_cogsamp;

User created.

SQL> create user gosaleshr identified by cognos default tablespace

tbs_cogsamp;

User created.

SQL> create user gosalesmr identified by cognos default tablespace

tbs_cogsamp;

User created.

SQL> create user gosalesrt identified by cognos default tablespace

tbs_cogsamp;

User created.

SQL> create user gosalesdw identified by cognos default tablespace

tbs_cogsamp;

User created.

4、为相关用户赋权限

SQL> alter user gosales quota unlimited on tbs_cogsamp;

User altered.

SQL> alter user gosaleshr quota unlimited on tbs_cogsamp;

User altered.

SQL> alter user gosalesmr quota unlimited on tbs_cogsamp;

User altered.

SQL> alter user gosalesrt quota unlimited on tbs_cogsamp;

User altered.

SQL> alter user gosalesdw quota unlimited on tbs_cogsamp;

User altered.

SQL> grant connect, resource to gosales, gosaleshr, gosalesmr,

gosalesrt, gosalesdw;

Grant succeeded.

SQL> grant create any view to gosalesdw;

Grant succeeded.

5、导入样例数据

imp gosales/cognos@zzhdb file=GOSALES.dmp log=imp_GOSALES.log full=y

rows=y indexes=y constraints=n
imp gosaleshr/cognos@zzhdb file=GOSALESHR.dmp log=imp_GOSALESHR.log

full=y rows=y indexes=y constraints=n
imp gosalesmr/cognos@zzhdb file=GOSALESMR.dmp log=imp_GOSALESMR.log

full=y rows=y indexes=y constraints=n
imp gosalesrt/cognos@zzhdb file=GOSALESRT.dmp log=imp_GOSALESRT.log

full=y rows=y indexes=y constraints=n
imp gosalesdw/cognos@zzhdb file=GOSALESDW.dmp log=imp_GOSALESDW.log

full=y

6、调整各用户之间的约束关系

SQL> @gs_or_modify.sql;


1、oracle中创建5个用户gosales, gosalesdw, gosaleshr, gosalesmr ，

gosalesrt，密码和用户名相同，并赋权,我赋的是DBA。
2、把cognos\c8\webcontent\samples\datasources\oracle 中的5个dmp.gz解压

为dmp
3. 登录pl/sql，导入dmp，顺序是这样的gosales\gosaleshr\gosalesdw

\gosalesmr\gosalesrt，导入时要和相应的用户对应
4. 登录cognos viewer，进入cognos administration-》配置-》数据源连接，

创建两个新数据源。
great_outdoors_sales对应用户gosales，great_outdoors_warehouse对应用

户gosalesdw
5. 将D:\cognos\c8\webcontent\samples\content\Cognos_Samples.zip拷贝

至..\c8\deployment文件夹下。并到cognos administration-》配置-》内容管

理，导入cognos_sample。
6. 至此，基本OK