Description | This analysis provides a geographical view to identify number of installed devices by device category in a specific region. The data is shown for the current month. |
Purpose | This analysis provides a map view that allows users to see type of meters installed by geographic region. It is especially helpful during AMI rollouts to determine the status of the rollout. |
Representation | The color-coded region on the map shows the device count in that area, along with the city and state details. The pie chart on the map shows the distribution of devices across various device categories in the selected area. The table shows the number of devices in each device category that are installed in a specific region. It also shows the percentage of total devices installed in that region. % of Total = (Installed devices in each category/Grand Total) * 100 |
Drill Down | No drill down |
Source Object | Service Point Snapshot Fact |
OAS Subject Area | MDM - Service Point Snapshot |
Metrics | Count of Devices, % of Total |
Description | This analysis shows the number of devices installed in the selected month, by their type or category. |
Purpose | Business users can quickly see the number of meter installed by device type. They can also see how the meter totals have changed from the past year. The analysis is especially helpful during AMI rollouts. |
Representation | The View By drop-down slices the details by device type and category. The first pie chart shows how the installed devices are distributed across the selected dimension attributes in the previous year. The second pie chart shows the distribution of installed devices across the selected dimension attribute in the current year. The table shows the number of devices and the percentage of total across various device categories in the selected month. % of Total = (Devices / Grand Total) * 100 |
Drill Down | The pie chart shows the quarter-wise details for the selected year. The data is shown per each device type. |
Source Object | Service Point Snapshot Fact |
OAS Subject Area | MDM - Service Point Snapshot |
Metrics | Devices, % of Total |
Description | Devices can be turned ON or OFF based on whether a particular customer needs power supply or not. This analysis shows the count of devices under each device category and device status. |
Purpose | This analysis provides business users with a summary of the device’s status by device type, e.g., ON (connected) or OFF (disconnected). |
Representation | The pie chart shows how the devices in various statuses are distributed. The table shows the count of devices and that count’s percentage out of the total for each combination of device status and category. % of Total = (Devices Count / Grand Total) * 100 |
Drill Down | The Devices and % of Total column links drill down to the Device Status Detail dashboard page for specific details on the status of various devices. |
Source Object | Service Point Fact |
OAS Subject Area | MDM - Service Point |
Metrics | Devices, % of Total |
Description | This analysis shows the count of devices based on the installation status (the device life cycle). |
Purpose | This analysis provides a summary of the device’s installation status (the device life cycle). It is especially helpful when looking at AMI meters to see the devices commissioned, decommissioned, etc. |
Representation | The pie chart shows how the devices in various life cycle states are distributed across the selected device category. The table shows the count of devices in a particular life cycle state and the percentage of that count out of the total. |
Drill Down | The Devices and the % of Total column links drill down to the Device Status Detail dashboard page for specific details about devices. |
Source Object | Service Point Fact |
OAS Subject Area | MDM - Service Point |
Metrics | Devices, % Total |
Description | This analysis shows the count of devices that were installed in the previous 15 months. |
Purpose | Using this tool, business users can monitor device installation trends and the sub trends (by head end system, model, etc.) within the overall volume of device installations. |
Representation | The View By drop-down slices the data by head end system, device type, device category, manufacturer, model, or geographical code. The stacked bar graph shows the number of devices (across the selected View By attribute) installed in each month, for the previous 15 months. The X-axis represents the month and year. The Y-axis represents the installed device count. Hover over the bars for specific details. The table displays the number of devices installed in each month (across each of the selected attribute) for previous 15 months. |
Drill Down | The Month Year column link drills down to show the day-to-day details. |
Source Object | Service Point Snapshot Fact |
OAS Subject Area | MDM - Service Point Snapshot |
Metrics | Installed Devices |
Description | This analysis shows the total number of devices that are installed and removed in the previous 15 months. |
Purpose | Using this tool, business users can monitor the trends for devices that are installed and removed in the field. They can analyze the installation demands over historical periods. This tool also helps to identify equipment problems, such as an increasing trend in device exchanges due to equipment failures. |
Representation | The line graph shows the count of devices that are installed or removed in each month, for previous 15 months. The X-axis represents the month and year. The Y-axis represents the device count. Hover over the lines for specific values. The table displays the count of installed devices and removed devices for each month. |
Drill Down | The Month Year column link drills down to view daily values for the selected month. |
Source Object | Installation Event Fact |
OAS Subject Area | MDM - Installation Event |
Metrics | Installed Devices, Removed Devices |
Description | This analysis shows a summary of devices that were sending measurements and then stopped for some reason. (“sending measurement” is only true for smart meters. Manual meters have to be read manually) Note: The data is broken into aging buckets. |
Purpose | This tool allows users to quickly see devices that have stopped working. It is helpful with AMI meters that can suddenly stop functioning, including aging columns that lets the user know how long measurements have been missing. Business users can analyze the trends by slicing the data into various attributes, such as service point type, device type, etc. |
Representation | The pie chart shows the distribution of devices that stopped receiving measurements by age buckets in the selected month. The View By drop-down slices the details by service point type, head end system, service provider, device type, manufacturer, and model. The table shows the number of devices and their percentage of total for the selected attribute. The details are shown across various age buckets. |
Drill Down | The Devices and the % of Total column links drill down to the Devices without Measurements Detail dashboard page for a detailed view. |
Source Object | Service Point Snapshot Fact |
OAS Subject Area | MDM - Service Point Snapshot |
Metrics | Devices, % of Total |
Description | This analysis shows a summary of new devices that never received any measurements since the time of their installation. |
Purpose | This analysis allows users to see meters that have never recorded measurements. It helps them identify faulty installations, devices configured improperly, manufacturing defects, MDM master data not setup properly, etc. |
Representation | The View By drop-down slices the details by service point type, head end system, service provider, device type, manufacturer, and model. The pie chart shows the distribution of devices that never received measurements in the selected month, for the selected attribute. The table shows the number of devices and their percentage of total for the selected month. |
Drill Down | The Devices and the % of Total column links drill down to the Devices Never Received Measurements Detail dashboard page for a detailed view. |
Source Object | Service Point Snapshot Fact |
OAS Subject Area | MDM - Service Point Snapshot |
Metrics | Devices, % of Total |
Description | This analysis shows a list of the top 100 devices that stopped sending measurements due to some reason. The data is displayed for the selected month. |
Purpose | Business analysts can use this detailed analysis to navigate back to the source Oracle Utilities Meter Data Management system and view specific details pertaining to a service point or device on the MDM 360 Degree View portal. They can investigate why measurements are not being received. |
Representation | The table shows the service point and device details, along with number of days the device has not recorded measurements. |
Drill Down | The Service Point and Device column links drill back to the MDM 360 Degree View portal in Oracle Utilities Meter Data Management. |
Source Object | Service Point Snapshot Fact |
OAS Subject Area | MDM - Service Point Snapshot |
Metrics | Days without Measurement |