Blog

  1. SAP® SuccessFactors® Reporting and Analytics Quick Tips: Paste in a list of filter values for your EC reports

    This post is another in a series of SAP SuccessFactors Reporting and Analytics Quick Tips. In this post, I’ll share with you SAP SuccessFactors’ recent enhancement that allows you to paste in a list of filter values when creating or running an Employee Central report.

    Pre-requisites

    Employee Central and Report-Canvas, a.k.a. ORD/Advanced Reporting.

    The Scenario

    Many of my customers have shared some variation of the following scenario in search of an efficient solution: You are your company’s HR Reporting Analyst for WorldCo, a multi-national corporation with 42,000 global employees. Shelia, a SVP from Finance has come to you with an urgent request–they are evaluating some new budget items and need your very popular Employee Details report for 135 specific employees. They have provided you their employee IDs and need the data ASAP.

    The Old Solution

    Prior to the Q2 2018 release, you had two typical options:

    1.  Type in each Employee ID one by one into a filter and run the report. Unless you are a 100+ WPM typist this is not a particularly efficient nor enjoyable task.
    2. Run the report for the entire organization, export to Excel, and then use VLOOKUP for those 135 employees. This is doable, but excessive Excel manipulation can lead to unintentional errors.

     Many of my customers have shared this scenario in search of an efficient solution.

    The New Solution

    Now, whether you are (a) creating/editing or (b) running a report, you have the option to paste in a comma-separated list of values into the Filter popup.

    Note: The max number of unique values is limited to 2000.

    It is that easy! Now you’re able to get that data over to Finance more quickly, and have some extra time in your day.

    Bonus: This new feature is simple enough that you could likely share this report with your end users and they could run the report on their own.

     

    ABOUT THE AUTHOR

    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

QUESTIONS? WE’VE GOT ANSWERS.

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.