WFA on Hana Succession Metric: Applicable Succession Positions Count

[MissZP]

Hi @YSE-1 :

We have a query regarding the WFA Succession measure Applicable Succession Positions. The client is using a position-based nomination method for Succession.

According to the specification, the Applicable Succession Positions measure should count the number of positions at the end of the reporting period. However, it appears to be counting the number of unique Successor IDs instead.

We noticed this during our review of the WFA Drill to Detail. The data provided focuses solely on Successor details, rather than on active positions. For example, if a department has 100 active positions but only 20 successors (with unique position IDs), the measure returns a value of 20.

Given the limited scope of the current measure, we wanted to understand whether the measure’s definition could be clearer or whether the code itself needs to be adjusted to better support position-based nominations.

How would we tweak this code to reflect the expected count—i.e. the number of positions rather than count of successors’ positions?

Thank you.

Best regards,

Zaklin Perosa

@mikehoekstra1 

[YSE-1]

Hi @MissZP ,

Because of the limitation in WFA on HANA where we have to use employee ID to do key mapping with Workforce fact, I think it was setup as such in the template.  If you want to tweak it using Position MDF, you need to have separate complex fact table with Position MDF as the sourcing.  However, you have to create separate hierarchies for this fact table as there is no employee ID in Position MDF thus you cannot reuse any hierarchy or dimension from Workforce fact table (i.e. Position fact on the left side and Workforce fact on the right side in the key mapping setting).

You can still do key mapping from Workforce or Succession fact table (i.e. Workforce or Succession fact table on the left side, Position fact table on the right side in the key mapping setting) to this new fact table based on position field.  That way you can reuse dimension/hierarchy from Position fact table for any metrics in Workforce or Succession fact tables.

cc. @Keegan 

[MissZP]

Hi Yuli,

Thank you for your reply!

We are reviewing the solution.

Best regards,

Zaklin

@mikehoekstra1