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.
成功导入表之后我们要做的 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".
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.
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.