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
