Working with producer-based and rule-based custom statistics

The warehousing engine is also responsible for the generation of user-defined statistics over collected data. Custom statistics can be:

  • Producer-based: Generated by a special object called Producer.
  • Rule-based: Generated by the warehousing engine after applying a rule defined by the administrator.


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.

Additional information

Only rule-based statistics that have no defined metric associations can be deleted.

Example of Custom statistics

Producer-based statistics

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

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

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.

Tip

Golden models and analyses store their results in a permanent way and can produce custom statistics.

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 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

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:

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:

      Note

      Basic properties  are displayed by default in the  Add new rule-based statistic page.
      Property Value
      Parameters
      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: You can aggregate your data by means of aggregation functions.
      • Percentile: You can calculate the percentile.
      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:

      • time filter: Lets you define the time span over which the statistic will be calculated by selecting a time span from the Time filter list.
        • Select the Time filter.
      • manually specified: Lets you define a specific time span span by allowing you to enter a particular time frame. This time frame can be specified in hours, days, weeks, months, years by selecting from the list displayed for Manually specified. You can also include the current time frame by selecting the checkbox next to the list. The name of this check box changes depending on the option you select in the list. For example, if you select days in the list, the check box name  displayed is Including current day.
        • Specify the details like in Years, Months, Weeks, Days, or Hours w/o Including current hour.
      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.
      Percentile
      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.

      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.

      Property Value
      Parameters
      Advanced aggregation function
      Input statistic

      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:
      • none: Select this option if you do not want to aggregate the result achieved after applying this rule.
      • aggregate points having: Select this option to specify one of the following aggregate conditions for applying the rule.
        • Select any of the Having conditions options: The same day class, The same week day, and The same month day.
      Percentile
      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).
    • Click Save to create the statistic.

    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 icon  enables you to recover historical data, while the Delete the association with this custom statistic icon lets you delete the association.

    Recovering historical data

    Was this page helpful? Yes No Submitting... Thank you

    Comments