SAP Knowledge Base Article - Public

2209656 - How to Run an Adhoc Report / Report Table in SuccessFactors - HXM Suite

Symptom

How to run an Adhoc Report in SuccessFactors?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HXM Suite

Resolution

  1. Go to Reporting option in Home Dropdown Menu
  2. Click on "New" button to create a new report

    2019-05-20_16-54-39.png

  3. Choose the report format type

    2019-05-20_17-02-48.png

  4. Select how you would like to have the data structured and choose the respective domain

    2019-05-20_17-05-50.png

  5. You must configure the sections accordingly the data you want to report

    2019-05-20_17-08-16.png

    General Info: fill all General Info's fields as desired

    2019-05-20_17-11-07.png

    Columns: on this section, you will select all the data you want to extract from the entity selected and in this example, we will be using Recruiting data. Click on "Select Columns" button:

    2019-05-20_17-21-02.png

    You can select the desired column and after the respective field. In this case, we selected "Application" and within the Application table, we choose "Address" field. Please, noticed the steps 1, 2 and 3. First the column, then the field and in the third step, you will have the list of selected field. It's possible to select more than one column and field, however take in mind that's important to select only data related to each other. We can't determinate all the relations among the fields and column, if a field doesn't have a connection with other field, the system will show a null data or show a inconsistent information, but you can always test and preview the file you are trying to create, by clicking the "Preview" button in the bottom right corner.

    2019-05-20_17-24-39.png

    After choosing the columns and fields, you have the ability to short, agroup and reorder the data:

    2019-05-20_17-34-18.png

    Configuration: on this section, according to the date reported, you will be able to configure the DataType and the valueID.

    2019-05-20_17-41-55.png

    Filters: on this section, you can select the criteria and filter the data you are reporting. In the following example, we want to extract Application information, but we want to report only data from Applications that the First Name is/or contains "John". Please check the following examples:

    2019-05-20_17-45-19.png

    2019-05-20_17-45-58.png

    2019-05-20_17-46-17.png

    2019-05-20_17-46-51.png

  1. Go back to General Info section and click on Save button. After saving, the report will be available in Report Center in My Reports tab
  2. If you want to execute the report now, the Generate button will be available, click on it and the following preview screen will be displayed:

    2019-05-22_10-05-43.png
  1. You must choose one of the available files types to download the report. 
  • CSV
  • Excel
  • PDF
  • PPT
  1. After choosing the type, the download will start.
  2. As mentioned, the report will be available to be executed as many times required, but also, you have a ability to edit the report again, among other options.

    2019-05-22_10-10-21.png

Keywords

SuccessFactors, SF, report, AdHoc Report, run report, reporting, tool, Analytics, Report Center, table, canvas, dashboard, tile, columns, filters , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Suite all versions