OTBI : Line Managers not retrieved in Workforce Management - Workforce Trend Real Time Subject Area

Summary:

We are creating a dashboard which shows attrition rate based on different aspects like country, departments, etc. We were fetching the query from OTBI analysis using Workforce Management - Workforce Trend Real Time subject area and found that there was mismatch in final outcome after concluding that many of the line managers are not at all getting picked in output.

Content (required):

Fact columns used

• "Workforce Trend"."Period Start Headcount"
• "Workforce Trend"."Period End Headcount"

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Uploading document of snapshots of interface screen.