Description | This analysis compares two months of usage summary for the selected usage snapshot type. |
Purpose | This analysis allows business users to analyze usage trends using time-of-use (TOU) maps. Users can view current and previous month's usage by TOU period, giving an overview of usage trends. |
Representation | The Usage Snapshot Type drop-down filters the data by the available usage snapshot types. The bar graph shows the month-on-month consumption quantity based on the TOU period. The X-axis represents the quantity (on/off/shoulder KWH (this on/off/shoulder KWH is a usage snapshot type and depends on the data) and the Y-axis represents the time of use. Hover over the bars for specific details. The table displays the usage quantity details against each time of use, for each month. |
Drill Down | No drill down |
Source Object | Consumption Fact |
OAS Subject Area | MDM - Consumption |
Metrics | Quantity |
Description | This analysis shows a summary of unreported usage per various age buckets in the selected month. |
Purpose | A usage is “unreported” when there is consumption, but it was never processed and sent for billing. Higher unreported usage means revenue loss to the utility. Business users should focus on bringing down the unreported usage quantity. |
Representation | Select the unit of measure, service point type, and unreported usage aging type for which you want to view the unreported usage details. The unreported usage details for various age buckets are represented as vertical gauge views, one for each bucket (such as < 30 days old, 31-45 days old, 45-60 days old, and > 60 days old). The vertical bar changes the color to indicate whether the data is within predefined limits. The inner rectangle of the vertical bar shows the current level of data against the ranges marked on the outer rectangle. The View By drop-down slices the details by usage subscription type, usage group, or customer class. The table shows the count of service points and percent of usage for the segment selected in View By. |
Drill Down | No drill down |
Source Object | SP Usage Transaction Fact |
OAS Subject Area | MDM - SP Usage Transaction |
Metrics | Service Point Count, Usage Quantity, % of Total |
Description | This analysis shows a 15-month usage trend by TOU period. |
Purpose | Using this tool, business users can monitor the trends in usage volume and also the sub trends based on time-of-use periods. |
Representation | Both the stacked bar graph and table show the usage summary against each TOU period. The X-axis represents the month and year, and the Y-axis represents the usage quantity. Hover over the bars for specific details. |
Drill Down | No drill down |
Source Object | Consumption Fact |
OAS Subject Area | MDM - Consumption |
Metrics | Usage Quantity |
Description | This analysis shows a 15-month non-normal usage trend sliced by condition code. Note: Non-normal usage classification is as done by the Oracle Utilities Meter Data Management system based on the Measurement Condition Category attribute. |
Purpose | Using this tool, business users can monitor the trends in non-normal usage (estimated, missing, etc.). This number should be trending down or very low. |
Representation | Both the stacked bar graph and table show the non-normal usage summary against each condition code. The X-axis represents the month and year, and the Y-axis represents the usage quantity. Hover over the bars for specific details. |
Drill Down | No drill down |
Source Object | Consumption Fact |
OAS Subject Area | MDM - Consumption |
Metrics | Usage Quantity |
Description | This analysis provides insight into usage associated with a combination of dimensions. The data is shown for the selected month. |
Purpose | This analysis provides a summarized view of the usage, allowing users to “slice” the database to perform custom data analysis. The three “View By” selections allow users to define the viewing hierarchy, such as all usage for this market, city and rate class (usage group). After the selection, the user is presented a summary of the data. |
Representation | The View By drop-down slices the details by service point type, market, usage subscription type, city, geographical code, postal code, service provider, or usage group. You can vary the combination of dimensions. The table displays a summary of usage and percentage of the total for the selected attributes. |
Drill Down | No drill down |
Source Object | Consumption Fact |
OAS Subject Area | MDM - Consumption |
Metrics | Usage Quantity |
Description | This analysis shows the top service points with the highest usage consumption in the selected month. |
Purpose | This analysis helps business users to identify the customers with highest usage, such as my top customers. It is very useful in customer analysis, rate planning, and contract renewal. |
Representation | The bar graph on the left shows the top 10 records with the highest usage quantity in the selected month. The X-axis represents the quantity and the Y-axis represents the rank. Hover over the bars for specific details. The bar graph on the right shows the consumption for top 100 service points and for the total service points. The X-axis represents the service points. The Y-axis represents the consumption. Hover over the bars for specific details. The table displays the top 100 records with highest consumption for the selected month. |
Drill Down | The Service Point column link drills back to the MDM 360 Degree View portal in the Oracle Utilities Meter Data Management system. |
Source Object | Consumption Fact |
OAS Subject Area | MDM - Consumption |
Metrics | Quantity |
Description | This analysis shows a list of service points with lowest consumption for the selected month. |
Purpose | This analysis helps business users to identify the customers whose consumption is low and allows them to drill back into MDM to determine if the meters are showing accurate readings. |
Representation | The table displays the top 100 records with lowest consumption for the selected month. |
Drill Down | The Service Point column link drills back to the MDM 360 Degree View portal in the Oracle Utilities Meter Data Management system. |
Source Object | Consumption Fact |
OAS Subject Area | MDM - Consumption |
Metrics | Quantity |
Description | This analysis lists the top 100 records with highest unreported usage quantity in the selected month. |
Purpose | Usage is “unreported” when there is consumption in Oracle Utilities Meter Data Management, but it has not been sent to billing. High unreported usage means revenue losses for the utility and slow cash flow. Business users should focus on bringing down the unreported usage quantity. Business analysts can use this detail-level analysis to navigate back to the source Oracle Utilities Meter Data Management system and view specific details pertaining to a service point or device in the MDM 360 Degree View portal. |
Representation | The table displays the service point and unreported usage quantity details for each service point. The data is shown for the selected month. |
Drill Down | The Service Point column link drills back to the 360 Degree View portal in the Oracle Utilities Meter Data Management system. The Account column link drills back to the Account portal in the Oracle Utilities Customer Care and Billing system. |
Source Object | SP Usage Transaction Fact |
OAS Subject Area | MDM - SP Usage Transaction |
Metrics | Usage Quantity |