Preparing the Tivoli® Data Warehouse for Tivoli Common Reporting includes creating the IBM_TRAM dimensions, which are required for running the Cognos® reports and using the data models.
Other dimensions conforming to the Tivoli Common Data Model, such as ComputerSystem, BusinessService, and SiteInfo.
You will need the database scripts included in the extracted reports package under the db_scripts directory.
If reports are distributed with an installer, the following manual procedures can be handled automatically by the report installer. See your agent-specific user's guide for information on automated TRAM creation.
When installing multiple report packages, the following steps need only be completed once. When installing multiple report packages the same TIME_DIMENSION tables are used. If you want to reset granularity or begin and end times, you can repeat the procedure.
Troubleshooting
If the DB2 commands
are failing with the following error:
UDA-SQL-0107
A general exception has occurred during the operation "prepare".[IBM][CLI
Driver][DB2/NT64] SQL0551N "ITMUSER" does not have the required
authorization or privilege to perform operation "SELECT" on object
"IBM_TRAM......