Configure the Analytics Options Extendable Lookup for High Bill Complaint Cases

The Billing Overview subject area in the Customer Cloud Service includes the High Bill Complaint Cases Count metric. This metric is calculated by counting (1) cases associated with bills, (2) cases that have a case type that are classified as "High Bill Complaints," and (3) cases that are not in a specific case life cycle state (for example, cases in a "canceled," "rejected," or "resolved" state). Before this metric can be used, it is necessary to configure the Analytics Options extendable lookup. For example, you may want to do the following:
  • Identify which characteristic type associated with a case can be used to identify the Bill ID on the case. This way, you can limit the cases to those associated with bills.
  • Since case types vary by utilities, you must specify which case types should be classified as "High Bill Complaints".
  • Identify life cycle states of High Bill Complaint cases (for example, cases in a "cancelled," "rejected," or "resolved" state) that should be excluded from the count.
To configure the lookup for High Bill Complaint cases:
  1. Navigate to your instance of Oracle Utilities Customer Cloud Service and log in.
  2. In the search menu, enter "Extendable Lookup."
  3. Do one of the following:
    • In the Business Object field, enter F1-AVAnalyticsOptions
    • In the description field, enter Analytics Options

  4. If this is the first time you are using this Analytics Options Extendable Lookup, click Add to create an extendable lookup for storing configurations that will be used by Oracle Utilities Analytics Visualization.

  5. In the Analytics Options page that displays, enter the following:

    • Option Name: OUAV Extendable Lookup Config
    • Description: OUAV Extendable Lookup Config
    • Detailed Description: OUAV Extendable Lookup Config
  6. Scroll down to the Billing Overview section.
  7. From the High Bill Complaint Case Type drop-down list, select one or more case types you want classified as "High Bill Complaints". You can select one or more case types. The sequence number must be unique for each selected case type.
  8. From the Exclude High Bill Complaint Case States drop-down list, select the life cycle states of these High Bill Complaint cases (for example, cases in a canceled, rejected, or resolved state) that should be excluded from the count.
  9. From the Bill ID Char Type on Cases drop-down list, select the characteristic type associated with a case that can be used to identify the Bill ID on the case.
  10. Save your configuration.