Configure Custom Buckets - Customer

Facts and dimension attributes in the dimensional data model provided by Oracle Utilities Analytics Visualization may contain numerical attributes that become more useful when grouping them into categories that represent specific number intervals. This process is often referred to as "binning" or "bucketing." For example, an age attribute value may be assigned to an age bucket such as 0-1 days, 1-2 days, 2-3 days, 3-4 days, or >=5 days.

Utilities business applications support a set of predefined bucket business objects that are used in Analytics Visualization. Intervals representing each bucket must be defined before the analytics solution can use bucket columns.

On this page:

Supported Buckets

Buckets must be configured in the Customer Cloud Service application by an administrator before they can be used by Analytics Visualization. The following buckets are currently supported.

Dimension

Importance

Bucket Value Ranges (Examples)

Column with Value to Be Bucketed

Column Details

Dimension: Completed in Billing Day Window Bucket

Attributes:

  • Bill Window Category
  • Bill Window Category Description
  • Billing Days in Window Bucket Config Code
  • End Range
  • Range Description
  • Sequence Number Code
  • Start Range

Identify the period in a bill cycle window when a bill was completed (for example, early in the bill cycle window).

Provides a meaningful illustration to users about when a bill was completed within its bill cycle window.

Example:

  • 0 to 1: Day 1
  • 1 to 2: Day 2
  • 2 to 3: Day 3
  • 3 to 4: Day 4
  • 4 to 99999: Day 5+

DAYS_COMPLETED_AFTER_WIN_STARTDays

Completed After Window Started

Bucket Column: Description

Business Object Name: Billing Day In Window Configuration

Business Object Code: C1-BillingDayInWindow

Dimension: Days Before Bill Window Closes Bucket

Attributes:

  • Bill Window Category

  • Bill Window Category Description

  • Billing Days in Window Bucket Config Code

  • End Range

  • Range Description

  • Sequence Number Code

  • Start Range

Identifies how much time is left in an open bill cycle window for a bill to be completed.

Provides a meaningful illustration to users about the time remaining in an open bill cycle window for a bill to be completed. Example:

  • 0 to 1: Day 1
  • 1 to 2: Day 2
  • 2 to 3: Day 3
  • 3 to 4: Day 4
  • 4 to 99999: Day 5+

DAYS_BEFORE_BILL_WIN_CLOSESDays

Before Bill Window Closes

Bucket Column: Description

Business Object Name: Days Before Bill Window Closes Configuration

Business Object Code: C1-DaysBeforeBillWindowCloses

Back to Top

Configure Custom Buckets

  1. Sign in to the Oracle Utilities application.
  2. In the search bar at the top of the screen, search for the "Bucket Configuration" menu and open it.
    A search for the Bucket Configuration options within Work and Asset Management
  3. In the Description field, enter the percent symbol (%) to search for any predefined buckets.

    Page to enter the search criteria for locating bucket configurations with an example of searching based on the description value

    Note: A newly installed application will not have any default configurations. If there are any records available, results will be displayed based on the search criteria. Select any of the bucket configuration records returned from search results to navigate and view the configuration.

  4. To add a new bucket configuration, click Add at the top right of the page.
  5. Select an option from the Bucket Configuration Business Objects menu. These options represent the placeholder for the bucket definition.
    Display of the items available in the Bucket Configuration Business Objects drop-down list
  6. In the Bucket Configuration field, define the bucket configuration code and its description. The code must be unique and should reflect the purpose of the bucket. For example, if the purpose of the bucket is for binning when a bill was completed within a bill cycle window, then your bucket configuration code could be CM-BILLDAYIW, where CM is a prefix that identifies that it is custom, and where BILLDAYIW represents that it is for binning Billing Day In Window.
  7. In the Bucket Value Ranges section, define a sequence of intervals for the start and end ranges that represents how the data should be grouped or binned. In most cases, the ranges must be continuous, and the start range must be the end range of the previous interval. The existing functionality will assign the attribute being binned into a range using the formula: Start Range <= x < End Range, where x is the numerical attribute being binned. The intervals must include all possible values of the underlying attribute that is binned into buckets. It is best practice to use a high value for the last end range to ensure that a large value is included in the interval defining the default bucket.
    Example of defining the bucket value ranges for a bucket configuration

Important Constraints: Follow these guidelines to avoid incorrect behavior of buckets.

  • Only one bucket configuration for each Bucket Business Object is supported by Analytics Visualization. Otherwise the application will return incorrect values and may double-count measures.
  • The bucket definition must have intervals that do not overlap and must cover all possible values. Otherwise, the application will return incorrect values and may under- or double-count measures.

Back to Top