Skip to Content

I want to pull a Headcount Report by age group with in an Organisation?

In SAP Analytics Cloud I want to create a report for Headcount by age group, Here my source system is SuccessFactors in SF they maintain Date of Birth field, By using this field I have to create this report, Is there any functionality to calculate age by using this D.O.B field in SAP Analytics Cloud.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 23 at 06:06 PM

    Hi Mudunuri,

    Sorry we don't have any functions that can look at date fields and perform calculations.

    Have you considered adding an age field in SFSF and then importing that?

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 28, 2017 at 10:39 AM

    Hi - unfortunately I don't have access to a SuccessFactors system to try this myself. I recommend starting by installing the free Business Content for SAP Analytics Cloud - it includes Human Resources -it should help guide you in the modeling - see https://blogs.sap.com/2016/11/18/sap-businessobjects-cloud-content/

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2017 at 03:18 PM

    Hi Tammy.

    Thank you for the information it was very useful. However, I could not add this packages to the demo system.

    1. Is there a way to query current date in SAP Analytics Cloud so that I can compare with the "Date of Birth" field in Success Factor and get the desired output.

    2. Is there a way to query current year(For Ex: Year 2017..Jan-Dec) in SAP Analytics Cloud so that I can show the report(ex:HeadCount) based on the calendar year.

    Add comment
    10|10000 characters needed characters exceeded