Analytics & Reporting

In a Nutshell

It’s vital that your business provides an unrivalled field service solution in order to remain competitive. The SAP Field Service Management Analytics & Reportings dashboard allows you to visually track key performance indicators, so that managers can see at a glance how departments, teams and employees are performing. Dashboard reports are the quickest and most effective means of representing data in an understandable and actionable manner.

With the Analytics & Reporting module it has never been easier to quickly build dashboard reports using pre-assembled queries, view and manage existing reports, and import report templates.

True business insight and intelligence is just a few clicks away.

A Closer Look

When you create a new record, you will enter the following information:

Field Description
Select a Sample Chart Here you can select from a number of the most commonly-used, high value queries.
Chart Title The title of the chart. By selecting a pre-built query, a default name will be generating. However, you can give the dashboard report your own unique name.
Chart Type The type of chart you would like the data to rendered in. Options include: column; pie; and line.

You can also create a dashboard report by selecting the Advanced Settings option:

Field Description
Query Here you can input your own SQL query
DTO In this field you must indicate which version of the Data Transfer Object (example: BusinessPartner.20) you would like to use.

The following is an example SQL Query:

SELECT, count( FROM Activity a JOIN BusinessPartner bp ON a.businessPartner =
WHERE a.checkedOut = false GROUP BY ORDER BY DESC LIMIT 20

How do I use it?

Create Report with Pre-built Query

The Reporting Dashboard includes pre-built queries addressing some of the most important dashboard scenarios you may face.

Modify Query DTO Version

You can return data for different version of a Data Transfer Object by selecting the Advanced Settings option from a Dashboard report, and updating the DTO version.

Analytics & Reporting Example

The following is an example of a line graph representing the service call volume by month:

The following settings were used to create this line graph:

Chart Title Service call volume by month (Line)
Chart Type Line
DTOs ServiceCall.20
Query SELECT COUNT(, sc.startDateTime FROM ServiceCall sc GROUP BY sc.startDateTime ORDER BY sc.startDateTime DESC
Sample Name Service call volume by month (Line)
xAxis Title Number of Service Calls
yAxis Title n/a

Viewing and Generating Reports

Reports can be generated and viewed by going to the Analytics & Reporting app and signing in with your SAP FSM account credentials.

After selecting the report you created from the Templates dropdown menu, you can then select the generate button to display the report.

Generated reports can then be downloaded by selecting the download icon from the action row. Generated reports can be downloaded to PDF, excel, and/or Word format.