OCC dashboards are the most flexible form of dashboarding in SAP Focused Run. It is completely up to you to define any dashboard based on the available data.
The explanation below will give a quick introduction on how to setup a dashboard with as example a line graph with CPU for one system and amount of short dumps per hour for that system in a bar chart.
Set up new dashboard
Start the OCC dashboard Fiori tile:
Click the add a new dashboard icon on the left:
Now open on the right hand side icon the personalization. Here you can change the default 2 by 1 layout if want as well:
Now per gadget, select the personalization. First choose the type of graph, then select the query details:
Add the query by clicking the Plus sign:
Give the legend a name and press the Change query button:
First select the data source. In this example we choose system monitoring. Select next your system, and select the metric (in this case CPU). Don’t forget to save on top of the personalization!
We repeat for the other gadget, but now select short dumps per last hour as example:
Test your dashboard to see if the results are according to your expectation.
Make dashboard public
If you are happy with your dashboard, you can make it public. To do so, go to the personalization options:
Set the selected page to public, select a proper icon, and rename the default user-edit to a proper name and don’t forget to Save.
Other users can now add you dashboard from their UI personalization menu by clicking the Add Public Page and add your dashboard:
ABAP short dump trend analysis
We can use SAP Focused Run OCC Dashboards to build a ABAP Dump Trend Analysis dashboard.
Using OCC Dashboard we can use the data provider for System Monitoring to pull the data of Short Dumps per day metric in to a trend chart.
In the OCC Dashboard app you can create a new dashboard page by clicking on Add Custom Page in the navigation panel.
By default your new page will be named as custom_page, you can rename your page by clicking on Rename in the settings section and then providing a new name.
In the View Management section of the settings area you can modify the grid layout. By default you have 2 columns in 1 row. In this example we will change to 1 X 1 to keep just the ABAP Dump Trend Analysis dashboard. (Note: we can add a dashboard to each grid in the layout).
Now for adding the dashboard to the pane we just created, we click on the settings button for that pane.
Then in settings area, under View Personalization –> Render we select the graph type. In this case we want to perform a trend chart so we select Line Chart.
Now we need to create a query for the chart that would provide the data for our graph. For this in the Query section we click on the + sign to add a query.
Now in the Query Section, for the newly added row you provide a name under Legend and then click on the change button to start editing the query.
In the Query Editor screen select the data provider System Monitoring.
Now we navigate to the Scope Selection tab to select the managed systems for which the dashboard should display data. In this example we selected System Type as Application Server ABAP and IT Admin role as Production to select all ABAP production systems.
Now in the Default tab , under Extended SID select any ABAP system and then under Metrics tab select the metric Number of Short Dumps (Today). Click on Apply button to activate the selection.
Now you can see the ABAP Dumps trend lines for the selected scope of managed systems in the graph.
Note: By default a graph for System Monitoring data provider will select Auto resolution of data which will show the data for today with hourly frequency.
You can change the resolution in the Time Range Section in the Settings area. For example here we set Period for last 30 days as “l30d” and Granularity for every day or daily as “d”.
Note: OCC Dashboard graphs will always average out the data as per the granularity set for the graph w.r.t actual collection frequency of the selected metric. For instance if the metric Number of Short dumps (Today) has a hourly frequency and we show the daily data in the graph, then the value shown in the graph will be average of all hourly data collected by the metric for that day, which will of course be different from the actual final daily count. Hence to ensure data shown on graph is accurate, ensure that the Number of Short Dumps (Today) metric has a daily frequency. Then the granularity of the graph and the metric data collection frequency being exactly same, both will have the exact same and accurate data.
To know more abut OCC Dashboards and all possibilities with it you can refer to SAP Documentation here.
<< This blog was originally posted on SAP Focused Run Guru by Frank Umans and Manas Tripathy (Simac). Repost done with permission. >>