How to Add Granularities to a Metric Definition

add_gran_642x301.png

Procedure

To add a granularity:

  1. Load the Define Metrics form and select the metric definition.
    Path : System / Add-In Manager / Define Metrics
    URL : http://localhost:8080/archibus/ab-ex-metric-metrics-def.axvw

    You can also define granularities using the System / Add-In Manager / Define Metric Granularities task.

    The form will present the list of existing granularities at the bottom of the page.

  2. To add a granularity, use the Add New action. The form will let you select from the list of pre-defined granularities.
  3. To delete a granularity, double-click the Granularity Title. The form will display a dialog for editing or deleting the granularity.

To review the list of pre-defined granularities, load the Define Granularities view:

Path: System / Add-In Manager / Define Granularities
URL : http://localhost:8080/archibus/ab-ex-metric-gran-def.axvw

Comments

The "All" Granularity. Most metrics have an "All" granularity which summarizes all information in the database for the given metric definition.

Existing Data. If you add or delete a granularity for an metrics on inventory tables, you will invalidate the previous metric trend value data which you have already collected. If you have an inventory metric in active use, you may wish to define a separate metric. This is not so for metrics on transaction tables, as these metrics can re-create their history.

Required Tables. If you opt to summarize a metric by a granularity the required fields for that granularity must exist in the table you list in the Collect: From Table. The exceptions are:

  • For Geo, Region, and Site; the logic makes the roll up via a join from the Buildings (bl_id) value, if present.
  • For Business Unit; the logic makes the roll up via a join from the Division Code (dv_id) value, if present.