Cisco Cisco Prime Service Catalog 10.0 Installation Guide

Page of 176
 
2-24
Cisco Prime Service Catalog Installation Guide
OL-31035-01
Chapter 2      Reporting Guide 
  Installing Reporting
Postinstallation Tasks
The postinstallation tasks consist of scheduling the ETL processes to be run. The amount of time each 
process takes to complete is proportional to the amount of data in the RequestCenter database which 
must be extracted and transmitted to the Datamart database.
Postinstallation Tasks for Reporting
Set up the following script as scheduled tasks on the Cognos machine. All scripts reside in the 
<Reporting_Install_Dir>\cognos\bin directory.
Postinstallation Tasks for Advanced Reporting
If you have Advanced Reporting, then you must also perform the tasks described in this section.
Step 1
On the Cognos machine, set up the following scripts as scheduled tasks. All scripts reside in the 
<Reporting_Install_Dir>\cognos\bin directory.
Standard Report Script
Description
update_datamart_std.cmd
This script extracts the data from the RequestCenter database and 
transmits it to the Datamart database. This data is used to refresh the 
Service Catalog Standard Reports. This script can be scheduled to run 
however often you want Standard Reports to be refreshed. Normally, this 
script can be scheduled to run once a day, at off-peak hours.