The warehousing engine is also responsible for the generation of user-defined statistics over collected data. Custom statistics can be:
For more information, see the following sections:
The Custom statistics page displays a table for each type, allowing you to overview producer-based statistics and to edit or delete rule-based ones.
Only rule-based statistics that have no defined metric associations can be deleted.
Example of Custom statistics
Producer-based statistics are generated by an object called Producer, which can be:
Not all models or analyses are able to 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 BCO Data Warehouse, you must change its default behavior by making it golden.
Golden models and analyses store their results in a permanent way and can produce custom statistics.
Promoting an analysis to Golden and specifying the publishing period
The production of custom statistics is now enabled: a scheduler task will execute the golden model or analysis with the specified frequency, and the produced results will be visible in the Custom stats page.
Rule-based statistics are calculated by the BCO DWH according to administrator-specified rules. You can add, edit or delete these stats using the icons provided in the table.
To create a new rule-based statistic, first you have to define the statistic, and then add system and business driver metrics to it.
There are three types of statistics that you can create; depending on the chosen type, the form will be slightly different:
In the Rule-based statistics table, click Add stat.
In the Add new rule-based statistic page, specify the following details:
|Name||Enter the name of the new rule-based statistic.|
|Description||(Optional) Enter a brief description for this rule-based statistic.|
|Type||The type of the statistic you intend to use. Select any one:
|Advanced aggregation function|
|Input resolution||Lets you select the input data. For example, if you want to create a statistic based on hourly values, you can decide to use Hour. Select any one: Detail, Hour, Day, or Month.|
|Input time period||
Select any one:
|Aggregation||Allows you to select which kind of aggregation you want to apply to the input data. For example Weighted average. The available options are Average, Weighted average, Duration weighted average, Minimum, Maximum, Sum, Expected sum, or Count.|
|Output||The time resolution of the output. The available options are A single point, A point for each hour, or A point for each hour class.|
|Input resolution||Lets you select the input data. For example, if you want to create a statistic based on hourly values, you can decide to use Hour. Select any one: Raw, Detail, Hour, or Day.|
|Time aggregation||The aggregation of the input data on which you want to calculate the statistic. Select Daily, Monthly, or Quarterly as appropriate.|
|Percentile order (P%)||Enter a percentage value to specify the distribution of data.|
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.
|Advanced aggregation function|
Select any one: Automatic - based on metric type, Average, Weighted average, Minimum, Maximum, Sum, Quadratic sum, Cumulative sum, Good samples, Warning samples, or Poor samples.
|Aggregation groups||Allows you to group the input data depending on the aggregate condition described as follows:
|Type of percentile||Select either Discrete (to pick data in its current form) or Continuous (for uniform distribution of data) to specify how data must be configured.|
|Input statistic||Select any one: Automatic - based on metric type, Average, Weighted average, Minimum, Maximum, Sum, Quadratic sum, or Cumulative sum.|
|Order||Lets you specify how the data used to calculate the statistic should be sorted (Ascending or Descending).|
The following figure displays the options for creating a rule based statistic:
Add rule based statistic
The next step is adding metrics to the statistic. To do so, click on the statistic's name in the Rule-based statistics table to open its detail page, where you will be able to add metrics by clicking Add system metric, Add business driver metric, or Add global metric.
Detail page for a custom rule-based statistic
Adding a new system metric to a 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 iconenables you to recover historical data, while the Delete the association with this custom statistic icon lets you delete the association.
Recovering historical data