ITM Agent Insight: TCR Report Dimension Table and troubleshoot UDA-SQL-0107 error
mehuldarji 270006DJ3G Visits (7362)
This blog is intended to help you understand and walk you through steps to create the necessary Dimension Table for the Tivoli Common Reports. Preparing the Tivoli Data Warehouse for Tivoli Common Reporting includes creating and populating the resource dimension table "ManagedSystem", which is required for running the Cognos reports and using the data models.
The following dimensions tables are created by this procedure:
You will need the database scripts included in the extracted reports package under the
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.
You can use IBM DB2, Microsoft SQL Server and Oracle as your database. In this blog I will explain how to create it using IBM DB2 procedure.
db2 connect to WAREHOUS <-- you want to connect as Administrator
Go to cd c:\T
db2 call IBM_
The time dimension tables are complete.
If the DB2 commands are failing with the following error:
Execute the following commands to resolve the issue:
Subscribe and follow us for all the latest information directly on your social feeds: