Case Study 2: Building a pod from the BMC Remedy AR System database
Calbro Services wants to show a summary of their incidents, broken down by assigned group. They also want to see the monthly and daily trend in incidents reported, also broken down by assigned group.
The BMC pods do not allow Calbro to display their incidents by assigned group, so they must create custom pods that use the BMC Remedy AR System data source.
Calbro pods and metrics
Calbro has decided to create the following three pods using the Pod Builder:
- Incident summary by assigned group
- Incident monthly trend
- Incident daily trend
The three pods are defined below.
A pod that shows the incidents for the business service by priority and status, filtered by varying time ranges and broken down by assigned group.
Pod Name & Description
Name: Incident summary by assigned group
Description: This pod contains a bar chart that summarizes the incidents, showing the count by priority and status, filtered by varying time ranges. For each segment selected in the bar chart, an Assigned Group breakdown will be displayed. A third chart component, a grid chart shows the incident details for the incidents displayed in the graph charts.
Behavior Definition: Calbro expects to be able to quickly view the priority and status of the incidents that were reported in a particular reporting period, then determine to which group the incidents are assigned. They can also view the details of the incidents that are displayed in the charts by selecting the grid view. For even more detail on the individual incident records, they can launch the BMC Remedy Action Request System from the pod.
UI Definition:This pod will contain three charts:
- A bar chart showing the number of incidents by priority. Each bar in this chart will show the total number of incidents in that priority by incident status, represented by colored segments. The data in this chart can be filtered by the time range selected in the drop down menu.
- A donut chart showing the breakdown of the incidents by the assigned group. This chart will show the data by priority and status, according to the segment selected in the bar chart.
- A grid chart showing details for the incidents displayed in the charts, by assigned group and time range, according to what is selected in the drop-down menus.This pod will utilize the layout Side by side with a third chart accessible through a chart selector in the Pod Builder.
Data Location and Definition: Incident records are stored in the BMC Remedy AR System. The incident records are displayed in each time range in the pod, based on the incident reported date.
A pod that shows the monthly incident report trend, filtered by varying time ranges and broken down by assigned group.
Pod Name & Description
Name: Incident monthly trend
Description: This pod will show the trend in the number of incidents reported each month.
Behavior Definition: Calbro expects to be able to view the trends in the incident report dates and the groups to which the incidents are assigned.
UI Definition: This pod will contain three charts:
- A trend chart showing the total number of incidents reported each month. The data in this chart can be filtered by the time range selected in the drop down menu.
- A donut chart showing the breakdown of the incidents by the assigned group, according to the data point selected in the trend chart.
- A grid chart showing details for the incidents displayed in the summary chart, by time range, according to what is selected in the drop-down menu.
This pod will utilize the layout Side by side with a third chart accessible through a chart selector in the Pod Builder.
Data Location and Definition: Incident records are stored in BMC Remedy AR System. The incident records are displayed in each time range in the pod, based on the incident reported date.
The incident daily trend pod is very similar to the incident monthly trend pod, except that the pod will show the trend in the number of incidents submitted each day rather than each month. The daily trend pod contains the same number and types of charts as the monthly trend pod.
To create the three pods, we must perform the following tasks:
- Prepare the data
- Create a data source
- Create a data view
- Create the pod
Each task is explained in the following sections.