cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

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,

Answers (2)

Answers (2)

0 Kudos

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.

TammyPowlas
Active Contributor
0 Kudos

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/