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