Cognos Sample for Oracle数据源

1、安装Cognos8.3 Sample

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

标红色部分是根据本机安装位置会有所不同。

SQL> create tablespace tbs_cogsamp datafile 'E:/DBMS/oracle/product/10.2.0/oradata/CM/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/admin@cm file=GOSALES.dmp  full=y rows=y indexes=y constraints=n
imp gosaleshr/admin@cm file=GOSALESHR.dmp full=y rows=y indexes=y constraints=n
imp gosalesmr/admin@cm file=GOSALESMR.dmp  full=y rows=y indexes=y constraints=n
imp gosalesrt/admin@cm file=GOSALESRT.dmp  full=y rows=y indexes=y constraints=n
imp gosalesdw/admin@cm file=GOSALESDW.dmp full=y

完成以上步骤后，通过Cognos Connection 来建立相应的数据源即可。

祝 工作顺利 天天开心 ！！！ O(∩_∩)O