Set Up the Dynamic Usage Group Extracts

Oracle Utilities Analytics Warehouse allows the use of usage groups to break down the meter data analytics facts. However, in Oracle Utilities Meter Data Management, usage groups are determined dynamically through an algorithm plugged into the usage subscription's type.

Due to this dynamic configuration of usage groups, it is difficult to determine and replicate the logic that will be involved in determining the usage group. A download table is created instead to store the effective usage groups for usage subscriptions.

Extract the Dynamic Usage Group

An idiosyncratic batch process can be run on Initial Load or Incremental Load mode to determine the effective dynamic usage group of usage subscriptions. The batch process also writes the results into the US usage snapshot download table. This batch job is recommended to run the incremental mode daily, and to ensure that data in the download table will not be stale. 

Run the Usage Subscription Usage Group Download (D2-DUGDL) batch process to determine the effective usage group of usage subscriptions.

Back to Top