Tuning and managing the Data Warehouse

Updating the data warehouse (DWH) is one of the most important activities of BMC Helix Capacity Optimization. The Data Warehouse administration menu lets you inspect and tune the mechanisms that control it. To access the Data Warehouse menus, click Data Warehouse from the Administration tab of the Helix Capacity Optimization Console.

The available options of the Data Warehouse menu are described in the following topics:

• Viewing the status of the data warehouse
• Adding and viewing Hierarchy rules
• Enabling automatic dismissal and purging of systems and business drivers
• Adding and managing metric profiles
• Configuring a metric profile
• How metrics data is summarized
• Working with custom statistics
• Viewing datasets and metrics by dataset and ETL module
• Viewing and adding formulas
• Classifying dates and times for data analysis
• Creating and running data feed health reports

Data flow reports allow you to keep BMC Helix Capacity Optimization imports under control, as the number of rows processed per day is a good indicator of the system's health.

When performing historical imports (for example, if you are planning to bulk load more than two million rows), it is strongly recommended to split the data in smaller chunks, limiting the amount of information processed at one time. This prevents congestion in the Near-Real-Time Warehouse engine.