Configure Custom Buckets - Customer

Facts and dimension attributes in the dimensional data model provided by Oracle Energy and Water Data Intelligence 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 Device Analytics. Intervals representing each bucket must be defined before the analytics solution can use bucket columns.

Supported Buckets

Buckets must be configured in the Customer Cloud Service application by an administrator before they can be used by Data Intelligence. 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

Configure Custom Buckets

1. Sign in to the Oracle Utilities source cloud application.
2. In the search bar at the top of the screen, search for the "Bucket Configuration" menu and open it.

   

3. In the Description field, enter the percent symbol (%) to search for any predefined buckets.

   

   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.

   

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.

   

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.