Description | This analysis provides a geographical view to quickly identify the count of device activities in a specific region. The data is shown for the selected month. |
Purpose | Using this map view, business users can view activity volumes in particular areas. Activities are often commands, but can be service orders, outage processes, or other processes. This view can be used to monitor command trends, such as disconnects going up in a particular city, if any. |
Representation | The color-coded region on the map shows the device activity count in that area, along with the city and state details. The City,State link broadcasts the region details to the Activity Distribution and Activities by Month analyses on the same dashboard page. |
Drill Down | No drill down |
Source Object | Device Activity Fact |
OAS Subject Area | Device Activity Fact |
Metrics | Count of Activities |
Description | This analysis provides insight into the distribution of device activities in a geographical area (postal code) across various dimensional attributes. The data is based on the postal code selected on the Device Activities map on the same dashboard page. |
Purpose | Using this tool, business users can analyze the distribution of device activities in a geographical area for the selected period. |
Representation | The View By drop-down slices the data by activity type, device type, head end system, manufacturer, or model. The City,State drop-down filters the data for the area with the respective postal code. The pie chart shows how the device activities related to each attributes of the selected dimensional attribute are distributed as a percentage of total. |
Drill Down | The pie chart drills down to the Activity Trend or Activity Analysis dashboard pages for activity specific details. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Count of Activities |
Description | This analysis shows a 15-month trend for the number of device activities in a geographical area. It also shows the yearly average. The data is based on the postal code selected on the Device Activities map on the same dashboard page. |
Purpose | Using this tool, business users can monitor activities carried out in a specific city, and also compare the volume, for each month, against the yearly average. |
Representation | The City,State drop-down filters the data for the area with the respective postal code. The bar graph shows the number of device activities for each month in the selected geographical area. The X-axis represents the month and year. The Y-axis represents the device activities. Hover over the bars for specific details. The line on the graph shows the average device activity count for the selected year. |
Drill Down | The graph drills down to the Activity Trend or Activity Analysis dashboard pages for activity specific details. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Count of Activities (Bar), Yearly Average (Line) |
Description | Every activity is worked upon for certain time before it is marked as complete. This analysis displays the average time (in DD-HH:MI:SS) taken for activities of various activity types to be completed. The data is shown for the selected month. |
Purpose | Using this tool, business users can understand which activity types, on average, take more time to complete. It allows users to see the response times for their AMI head end systems. |
Representation | The Head End System drop-down filters the activities related to the respective head end system. The bar graph shows the average completion duration of the activities across various activity types. The X-axis represents the average completion duration in seconds. The Y-axis represents the activity types. Hover over the bars for specific details. The table displays the number of activities and their average completion duration for each activity type. The duration is shown in the <days>-<hours>:<min>:<sec> format. |
Drill Down | The Average Completion Time (DD-HH:MI:SS) column link drills down to the Activity Duration dashboard page for activity duration details for the selected activity type. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Count of Activities |
Description | This analysis shows the trend in the number of activities across various segments, for the previous 15 months. |
Purpose | Using this analysis, business users can monitor the volume of device activities carried out by the utility. The analysis can be used to see command trends, such as the disconnects going up, if any. The monthly graph also has stacks to further classify the volume based on activity type, device type, etc. It helps users to understand sub trends within the overall volume of activities. |
Representation | The View By drop-down slices the data by device type, activity type, head end system, manufacturer, or model. First graph: The stacked bar graph shows the 15-month trend in the total number of activities per the selected View By option. Each stack indicates the number of activities of a particular type. The X-axis represents the year and month. The Y-axis represents the number of activities. Hover over the bars for specific values. Second graph: Use the slider to view the data for a specific month. The bar graph shows the number of activities per each segment selected in the View By drop-down, for the selected month. The X-axis represents the selected attribute. The Y-axis represents the number of activities. Table: The table displays the number of activities per each attribute in the selected View By option. The data is shown for previous 15 months. |
Drill Down | The Month Year column link drills down to the Activity Analysis dashboard page for a granular view. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Count of Device Activity |
Description | This analysis shows the number of activities associated with a combination of various segments. It also indicates the percentage of total activities contributed by the selected combination. The data is displayed for the selected month. |
Purpose | This analysis provides a summarized view of activities. It allows users to “slice” the database to perform custom data analysis. The three “View By” selections allow users to define the viewing hierarchy, such as head end system, activity type, and city. Once the selection is made, the user is presented a summary of the data. The user can then drill into the details to see the particular device/service points in question. |
Representation | The View By drop-down slices the data by head end system, activity type, device type, manufacturer, model, geographical code, or city. The table displays the number of activities and percentage of the total for each attribute selected in the View By drop-down. % of Total = (Activities / Grand Total) * 100 |
Drill Down | The Activities column link drills down to the Activity Analysis Detail dashboard page for more detailed information. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Activity Count, % of Total |
Description | This analysis shows a comparison of the activity duration between the selected dimensional values based on the selected comparison dimension. The data is displayed for the selected month. |
Purpose | This analysis serves as a comparison tool for analysts to view the volume of activities and their average completion time against two specific values for any chosen dimensional attribute, such as comparing one head end system with another. |
Representation | The Comparison Dimension drop-down allows you to select the dimension for which you want to compare information for. You can select either head end system, device type, service provider, manufacturer, model, or city. The Dimension Value 1 and Dimension Value 2 drop-downs filters allows you to select the dimensional values that you want to compare. The bar graph displays the average duration for each activity category in the selected dimension values. The X-axis represents the activity category. The Y-axis represents the average duration (in seconds). Hover over the bars for specific values. The table displays the number of device activities and average completion time pertaining to each activity type and category. These details are shown for each of the selected dimension values. |
Drill Down | The Average Completion Time (DD-HH:MI:SS) column link drills down to the Activity Analysis Detail page for activity specific details. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Count of Activities, Average Completion Time |
Description | This analysis shows a list of the top 100 service points (in each customer class) with the highest number of activities in the selected month. |
Purpose | Business users 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, device, and activity details for each customer. |
Drill Down | The Service Point and Device column links drill back to the MDM 360 Degree View page in the Oracle Utilities Meter Data Management system. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Count of Activities |
Description | This analysis displays the top 100 device activities with longest duration. Along with the activity type and duration, the analysis also provides information about device, service point, and customer associated with each activity. |
Purpose | This tool helps business users identify the longest running activities. It identified the problem areas where a processes are not completing, such as a meter is not connecting. 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, device, activity type, and actual activity duration details for each customer. |
Drill Down | The Service Point and Device column links drill back to the MDM 360 Degree View page in the Oracle Utilities Meter Data Management system. |
Source Object | Device Activity Fact |
OAS Subject Area | MDM - Device Activity |
Metrics | Actual Activity Duration |