【分享】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 来建立相应的数据源即可。