Toolkits for the collection of data (Metricus Data Mart). Metricus is built on Microsoft architecture and uses SQL Server SQL Database for the collection of data related to defined IT Performance metrics. This includes:
- IT Entity table structures for the integration of data required to provision metrics values and provide supporting drill-through data;
- Metrics table structures related to the storage of metrics, calculation of metric values and storage of metric history, calendar details, data hierarchies, scoring and trend parameters, and scoring hierarchies.
|
SQL Server Integration Services packages for management of data related to defined IT Performance metrics. This includes:
- Template packages for loading data from all major IT enterprise management systems into the IT Entity tables e.g. loading data from HP ServiceCenter Incident Management into the [ITE Incidents] table
- Packages to populate Metrics table structures from IT Entity tables e.g. scoring, trending
- Packages to load pre-processed data into the Metrics module i.e. direct loading of metrics values from an XLS file
- Packages related to jobs required for the ongoing maintenance of metrics e.g. data loads, cube processing and data quality routines
- Automatic generation of metrics and scorecards in Microsoft PerformancePoint 2007
|
SQL Server Analysis Services database configured and optimized for the analysis of IT Performance metrics via PerformancePoint 2007. Includes:
- Standard cube structures and dimensions for metrics and supporting data from IT Entity tables
- Business Intelligence capabilities and functionality supporting PerformancePoint 2007 e.g. named sets, calculated measures.
|