'); $("#tabs").tabs({ selected: 1 }); $("#ic-homepage__ic-tips").append( quickTipHTML() ); unhideOneProductTip(); $("#ic-homepage__product-tips").wrapInner('
'); $("#ic-homepage__feed-tips").wrapInner('
'); });
IBM Tivoli Monitoring > Version 6.3 > User's Guides > Agent Builder User's Guide > Cognos data model generation > Prerequisites to generating a Cognos data model > Tivoli Data Warehouse IBM Tivoli Monitoring, Version 6.3
Populate the Tivoli Data Warehouse with the Tivoli Reporting and Analytics Model
Use provided database scripts to populate the Tivoli Data Warehouse
Tivoli Reporting and Analytics Model (TRAM) contains the base-set of knowledge that is common to all reporting packages. TRAM is installed by a set of scripts unique to each database. The necessary scripts for populating each supported database are included in the agent installation image, within the reports directory. Use the following procedure to create Tivoli Reporting and Analytics Model Common Dimensions in Tivoli Data Warehouse.
Procedure
- Browse to the Tivoli Reporting and Analytics Model database scripts.
- Extract the agent package.
- On Windows systems, agent package is kxx.zip.
- On Linux and UNIX systems, agent package is kxx.tgz.
- Go to the appropriate database scripts.
- DB2 scripts are in the Agent package at:
reports/db2/Kxx/reports/cognos_reports/itmkxx/db_scripts
- Oracle scripts are in the Agent package at:
reports/oracle/Kxx/reports/cognos_reports/itmkxx/db_scripts
- Microsoft SQL Server scripts are in the Agent package at:
reports/mssql/Kxx/reports/cognos_reports/itmkxx/db_scripts
- Run the database scripts to generate the common dimensions within the Tivoli Data Warehouse. Each script set provides a readme file for usage instructions.
- Verify that the scripts added the following tables to the Tivoli Data Warehouse:
"Computer System", WEEKDAY_LOOKUP, MONTH_LOOKUP, TIMEZONE_DIMENSION, TIME_DIMENSION
Parent topic:
Tivoli Data Warehouse