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 bp.name, count(bp.name) FROM Activity a JOIN BusinessPartner bp ON a.businessPartner = bp.id WHERE a.checkedOut = false GROUP BY bp.name ORDER BY bp.name 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: Setting Chart Title Service call volume by month (Line) Chart Type Line DTOs ServiceCall.20 Query SELECT COUNT(sc.id), 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.