Working with custom statistics

Use the Custom statistics page in the Helix Capacity Optimization Console to analyze and manage the custom statistics generated by the warehousing engine. Custom statistics can be rolling, produced-based, or rule-based.

The Custom statistics page displays tabs for each type, allowing you to overview producer-based statistics and manage rule-based and rolling statistics. To access the Custom statistics page, click Administration > DATA WAREHOUSE > Custom statistics.

For more information on types of custom statistics, see the following:

• • Rolling statistics
  • Producer-based statistics
  • Rule-based statistics

Rolling statistics

Rolling statistics is a combination of entity type and metric, and created by computing percentile statistics on a metric. These percentile values are computed for the last 1,7, and 30 days for the selected metrics.

BMC Helix Capacity Optimization includes the rolling statistics for predefined set of entities and metrics. Right-click here and select Save link as to download the Excel file that includes the list of out-of-the-box rolling statistics.

If you want to compute rolling statistics for additional metrics, use the Rolling Statistics tab to create custom rolling statistics. This tab displays a list of the existing out-of-the-box and custom (user-defined) rolling statistics and enables you to define new ones.

By default, the custom views created using the Tree map and Sunburst templates use these rolling statistics. 

The Rolling statistics table displays the following:

• System/business driver type: Entity type associated with a metric of the custom statistics.
• Metric name: Name of the metric.
• Package: Package for the statistics. 
  • Extension for Distributed Systems: Indicates that this rolling statistic is an out-of-the-box statistic.
  • [Custom]: Indicates that this rolling statistic is a user-defined statistic.

• Type: Entity category of the statistic.

To add rolling statistics

1. Navigate to Administration > Data Warehouse > Custom statistics. By default, the Rolling Statistics tab is displayed.
2. In the Rolling statistics tab, select Actions, and click Add Rolling statistics.
3. In the Add Rolling statistics page, specify the following details:
   1. Entity category: Select an entity category as System or Business Driver. 
   2. Entity type: Select entity types based on the selected entity category.
      1. Click Edit.
      2. In Available items, a list of entity types corresponding to the selected entity category is displayed. For example, if you have selected System as an entity category, all available system types are displayed.
      3. Select the entity type and click  to move to Selected Items.
      4. Click Apply. The selected entity types are displayed.
   3. Metric: Select metrics based on the selected entity types.
      
      1. Click Edit. 
      2. In Available items, several categories of metrics corresponding to the selected entity types are displayed.
      3. Select the metrics and click to move to Selected Items.
      4. Click Apply. The selected metrics are displayed.
4. Click Save. 
   The rolling statistics are calculated based on last 1, 7, and 30 days of data.
   
   

Producer-based statistics

Producer-based statistics are generated by an object called Producer, which can be:

• A model that generates predictions (for example, the residual capacity of an application)
• An analysis that summarizes collected data (for example, the weekly trend of a system KPI)

Not all models or analyses can produce custom statistics, as their result charts are only saved as images while the data used to build the results is not stored. If you want a model or analysis to produce statistics that will be saved and historicized into the Data Warehouse, you must change its default behavior by making it golden.

To save a producer-based statistic

1. Create a model or analysis as described in Editing-and-maintaining-models or Creating-an-analysis
2. Run the model or analysis and check the correctness of its results
3. Using an administration account, visit the main page of the new model or analysis and click Promote to Golden.
   The Promote to Golden option
   
4. Select the publishing period, that is the update frequency and click Save; the available options are: daily, weekly or monthly

Promoting an analysis to Golden and specifying the publishing period

The production of custom statistics is now enabled. A scheduler task runs the golden model or analysis with the specified frequency, and the produced results are displayed in the Custom stats page.

Rule-based statistics

Rule-based statistics are calculated by the data warehouse according to administrator-specified rules. You can add, edit, or delete these stats using the icons provided in the table. Only rule-based statistics that have no defined metric associations can be deleted.

To create a new rule-based statistic, define the statistic, and then add system and business driver metrics to it.

To create a new rule-based statistic

1. Navigate to Administration > Data Warehouse > Custom statistics.
2. In the Rule-based statistics table, click Add stat.

3. In the Add new rule-based statistic page, specify the following details:

   • Basic properties
   • Advanced properties

   Note

   To view or configure Advanced properties, click Advanced. You do not need to set or modify these properties unless you want to change the way the rule-based statistic works. These properties are for advanced users and scenarios only.

   

4. Click Save to create the statistic.

To add metrics to the statistic

1. Click the statistic's name in the Rule-based statistics table to open its detail page. 
2. Click Add system metric, Add business driver metric, or Add global metric. 
3. Add metrics and click Save.

Detail page for a custom rule-based statistic

As you create new associations, they will be listed in the corresponding table of the statistic's detail page.

The Historical recovery icon  enables you to recover historical data, while the Delete the association with this custom statistic icon lets you delete the association.