SAP Knowledge Base Article - Public

2438969 - Selecting units in custom sets & members without child units


How can a custom member or set include a unit in a dimension but not the units underneath it?


SAP SuccessFactors Workforce Analytics - Query Workspace


An org unit selected in a custom set or member includes everything in the org units underneath it.  There is no option to keep this from happening, so the way to retrieve only the employees in the grouping unit is to subtract the employees underneath. 

Make a custom member/set that contains only the top unit and another which includes every unit beneath it in the structure but NOT the top unit.  Subtract the latter from the former in a custom calculation or using a composite query, and at least in the case of a base measure like EOP Headcount the difference will be the total for the single unit.  In the case of calculated measures like termination rates, more complex calculations may be required.


KBA , LOD-SF-WFA-WA , Workforce Anaytics , How To


SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors Workforce Analytics all versions