OTBI report to display 3 years headcount taking year as input parameter

Question

Hi All,

I need to build an OTBI report to display active headcount of company for previous 3 years taking year as input parameter. Please help.

Below is the exact requirement:

Bar graph for showing the Growth Rate (across all BU) for past 3 years.

Roopadevi-Oracle · Answer

Hi Thanks for your response.

Yes i have looked into these turnover report and documentation.

But the requirement is to display all 3 years headcount in same report with respect to BU. That is where i am unable to proceed. Please advise.

Thanks

Bhaskar Konar · Answer

Hi @Roopadevi-Oracle,

Additionally, please find below few sample reports which will provide a good starting point and might be extended as per your requirement.

Headcount and Turnover by Country — Cloud Customer Connect

Headcount, Hires and Terminations Trend — Cloud Customer Connect

Hope this help.

Thank you.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/27582/otbi-report-to-display-3-years-headcount-taking-year-as-input-parameter

Hi @Roopadevi-Oracle,

Please find below docs which might be useful for the initial understanding and will help you to achieve your requirement.

https://docs.oracle.com/en/cloud/saas/human-resources/faohb/What-is-the-headcount-for-the-last-3-years-BQ-958.html#Subject-Areas

How to Effective Date a Headcount Report? — Oracle

Hope this help.

Thank you.