1. SAP SuccessFactors Reporting and Analytics Quick Tips: Ensuring EC Reports Return Results in All Languages

    By: Mike Hoekstra, Professional Services Consultant

    This post is the second in a series of SAP SuccessFactors Reporting and Analytics Quick Tips.

    As you’re likely aware, SAP SuccessFactors enables numerous localizations across the HCM Suite. Do you share your Employee Central reports (Canvas/ORD/Advanced Reporting) with a global audience? In this post, I’ll show you how to ensure that these reports successfully return results for employees running the reports in a different language.


    • Employee Central
    • Canvas/ORD/Advanced Reporting
    • Knowledge of your code/label mappings



    How your Canvas/ORD/Advanced Reporting Reports could return incomplete results

    For many fields in Employee Central, there are three versions of each field. Using Employee Status as an example, there is

    1. Employee Status–an internal ID
    2. Employee Status (External Code)
    3. Employee Status (Label)

    When creating filters in your report, it is typically most straightforward and logical to use the Label version of a field.

    A simple example would be if you are creating a report in US English, and filtering on Employee Status. Let’s say you want to include employees with Active, Paid Leave, Unpaid Leave, and Suspended statuses.

    Filtering on Employee Status (Label), you can choose these values as follows:

    This report will complete just fine when your report consumer uses English (US).

    However, when a user in another language runs the report, their values for the labels may change. For a French user, if those labels are different, no rows will be returned:

    Even if you aren’t a French speaker, if you’ve created and/or run enough Advanced Reporting reports in the past, you’ll recognize this as the dreaded “No Data Returned” message.

    The fix: Filter with External Codes

    What to do to fix this? Instead of filtering on the Label version of a field, you need to filter on the External Code version.

    So now change your filter to be on Employee Status (External Code): 

    Now, your report will accurately return results for users in all languages.

    But I don’t know my code/label mappings!

    If you don’t know your code/label mappings, you have a couple of options to find these:

    1. Create a quick query that includes codes and labels for your desired field(s); export this to Excel and filter on unique values.
    2. Consult your implementation documentation/workbook that lists these code/label pairs.

    Contact Aasonn to learn more about SAP SuccessFactors and how Aasonn empowers the HR team to transform the enterprise.

    Mike Hoekstra is an SAP® SuccessFactors® Reporting and Analytics expert at Aasonn, an SAP® Gold Partner.  He is certified in SAP® SuccessFactors® Reporting Tools, and as a Workforce Analytics (WFA) Technical and Functional Consultant.  He leads new implementations, delivers training sessions, and assists clients in developing complex reports and analyses. Follow him on Twitter @HoekAnalytics


You don’t learn everything in life by reading a manual. So, if you have questions about our products, services, implementation, getting started, or anything else, please ask us. Our highly trained staff is ready to help.