HCM Workforce Succession Planning - to get Successor and also Position details together

Saumya Gupta - Infosys

Hi All,

I am trying to show both successor's details as well as position holder's details together in a BI report, but even when I choose details from different HCM subject areas still im not getting desired output.The report layout should be:

POSITION HOLDER'S ID | POSITION HOLDER'S NAME | POSITION NAME | SUCCESSOR COUNT | SUCCESSOR PLAN LAST UPDATED

So for this I used 2 subject areas, "Workforce Succession Management - Position Plans Real Time" for Position holder's details and "Workforce Succession Management - Plan Candidates Real Time" for count of successors, but as soon as I added count of successors I get details of all the candidates as well and the count comes as 0.

For ex, there is 1 position with details: 1234 | Abc | Techie and this position has 2 successors, the desired output is:

1234 | Abc | Techie | 2 | 07/07/2016

But Im getting output as:

1234 | Abc | Techie | 0 | 07/07/2016

333 | S1 | Techie | 1 | 07/07/2016

444 | S2 | Techie | 1 | 07/07/2016

Could you please give your inputs.

Thanks in Advance