SAP Field Service Management can present Dashboards with key performance indicators, to help keep users informed. A dashboard can consist of one or more charts, each chart representing a key performance indicator. The data is sourced from the company database. You can use several built-in charts, or create your own. This feature can be found under Analytics and Reporting → Dashboards. Dashboards and charts are also available on mobile, although they may be less appealing visually.
The charts in the reporting dashboards include pre-built queries addressing some of the most important dashboard scenarios you may face. In addition to this, you can define your own queries in order to create your own customized charts.
For creating charts using pre-built queries, the following fields are important to know:
- Select a Sample Chart: Here you can select from a number of useful queries.
- Chart Title: The title of the chart. By selecting a pre-built query, a default name will be generated. However, you can give the chart your own unique name.
- Chart Type: The type of chart you would like the data to rendered in. The options include column, pie, and line charts.
You can also create a chart by selecting the Advanced Settings option in case you want to modify or enter your own SQL query.
- Query: Here you can enter your own SQL query.
- DTO: In this field, you must indicate which version of the DTO (for example, BusinessPartner.20) you would like to use.
However, there are some limitations to charts. These include the following:
- There can be only one query per chart
- The query must be written in CoreSQL (the same as is being used for Query API).
- it is not possible to drill down to see the underlying data
In case more in-depth analytics are required for data from FSM, it is recommended to use SAP Analytics Cloud. A standard interface is available to pull the data from FSM.
For integration to other analytics systems, FSM APIs like Query API and Data API can be used to pull the data into those systems.
Within SAP Analytics Cloud, there are several default Stories:
- Performance Dashboard: includes several key performance indicators like: First Time Fix and insights into time and material booked by technicians
- Capacity Overview: compares available capacity based on WorkTimePatterns to the backlog, while allowing distinction between internal and external workforce.
SAP Analytics Cloud allows you to fully customize your analyses, charts, KPIs, and so on.