IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Administrator's Guide > Tivoli Common Reporting
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Create and maintain the dimension tables
Prepare the Tivoli Data Warehouse for Tivoli Common Reporting includes creating the dimension tables, which are required for running the Cognos reports and using the data models.
There are two groups of dimension tables:
- Time dimension tables
- The time dimension tables, TIME_DIMENSION, MONTH_LOOKUP, and WEEKDAY_LOOKUP, are required by Tivoli Common Reporting. The time dimension tables belong to the IBM_TRAM schema. TRAM stands for Tivoli Reporting and Analytics Model, and is the common data model used by Tivoli products.
- The OS Agents Report Prerequisites Scanner report refers to these tables as the Tivoli Common Reporting Shared Dimensions.
- The following descriptions apply:
- IBM_TRAM Schema
- TRAM stands for Tivoli Reporting and Analytics Model, is the common data model used by Tivoli products.
Warning: When your site changes either the IBM Tivoli Monitoring data model or the operating system agent reports, your updated data model and reports are no longer supported. In addition, these updates can be lost when you apply maintenance to Tivoli Monitoring or move to a subsequent release.
- TIME_DIMENSION table
- Includes years of time dimensional data and granularity to a specified number of minutes. Each row of this table is a unique minute key with various dimensions related to it, such as hour, weekday, day of month, and quarter.
- MONTH_LOOKUP table
- Globalizes the month names for Time Dimension.
- WEEKDAY_LOOKUP table
- Globalizes the weekday names for Time Dimension.
- Resource dimension tables
- The resource dimension tables are MANAGEDSYSTEM, MANAGEDSYSTEMLIST, and MANAGEDSYSTEMLISTMEMBERS.
- The OS Agents Report Prerequisites Scanner report refers to these tables as the IBM Tivoli Monitoring Shared Dimensions.
- The following descriptions apply:
- MANAGEDSYSTEMLIST table
- Contains the name, product, and description (which is blank by default and can be customized) for the managed system group on the monitoring server.
- MANAGEDSYSTEMLISTMEMBERS table
- Contains the managed systems that are a member of a given managed system group as defined in the MANAGEDSYSTEMLIST table.
If you are running your Summarization and Pruning agent in autonomous mode (KSY_AUTONOMOUS=Y), the MANAGEDSYSTEMLIST and MANAGEDSYSTEMLISTMEMBERS tables cannot be maintained or created by the Summarization and Pruning agent.
There are three ways to create the dimension tables:
- Configure the Summarization and Pruning agent to create and maintain the dimension tables
In IBM Tivoli Monitoring V6.3 or later, you can create your tables using the Summarization and Pruning agent. Following the steps in this topic also configures the Summarization and Pruning agent to automatically maintain the dimension tables.
- Create the dimension tables using the Schema Publication Tool You can execute the SQL scripts created by the Schema Publication Tool to create your dimension tables. If you want your dimension tables to be maintained automatically, you must configure the Summarization and Pruning agent to do so after you have used the SQL scripts to create the dimension tables.
- Manually creating and maintaining the dimension tables
Prior to IBM Tivoli Monitoring V6.3, you had to manually create and maintain the dimension tables. If you want to continue to manually update the dimension tables, this option is still available.
Configure historical data collection before you begin
You must first configure historical data collection.In order to build the resource dimension table, configure historical data collection for one or more of the following attribute groups, depending on the operating system you are getting reports for:
Type Attribute group Table Summarize Linux Linux IP Address Linux_IP_Address Daily UNIX UNIX IP Address UNIX_IP_Address Daily Windows Computer Information NT_Computer_Information Daily Warehouse Summarization and Pruning Agent KSY Summarization Config KSY_Summarization_Config_DV Daily IBM i Miscellaneous i5OS_Miscellaneous Daily You can configure historical data collection in the Tivoli Enterprise Portal or in the Command Line Interface. The following example shows how a local historical collection for NT Computer Information was created and distributed from the CLI:
tacmd login -s MyComputer -u MyUser -p MyPassword tacmd tepslogin -s localhost -u sysadmin tacmd histconfiguregroups -t knt -o "NT Computer Information" -m -d YQMWDH -p Y=2y,Q=2y,M=1y,W=1y,D=6m,H=14d,R=7d tacmd histcreatecollection -t knt -o "NT Computer Information" -a "ComputerInformation" -c 15m -i 15m -l TEMA -e "Needed for resource dimension table for TCR." tacmd histstartcollection -n TEMS_NAME -t "knt" -o "NT Computer Information"
Warning: When your site changes either the IBM Tivoli Monitoring data model or the operating system agent reports, your updated data model and reports are no longer supported. In addition, these updates might be lost when you apply maintenance to Tivoli Monitoring or move to a subsequent release.
- Configure the Summarization and Pruning agent to create and maintain the dimension tables
Configure the Summarization and Pruning agent to create and maintain the dimension tables required by Tivoli Common Reporting and IBM Tivoli Monitoring. The time dimension tables, TIME_DIMENSION, MONTH_LOOKUP, and WEEKDAY_LOOKUP, and the resource dimension tables, MANAGEDSYSTEM, MANAGEDSYSTEMLIST, MANAGEDSYSTEMLISTMEMBERS, are all created and maintained using this procedure.
- Create the dimension tables using the Schema Publication Tool
Use the schema publication tool to create the dimension tables required by Tivoli Common Reporting and IBM Tivoli Monitoring.
- Manually creating and maintaining the dimension tables
You can create the dimension tables by creating and maintaining them manually using database scripts.
Parent topic:
Tivoli Common Reporting