This content has been marked as final. Show 3 replies
A few things to consider:1 person found this helpful
1. If you are trying to alter the actual "Headcount" metric, then you need to edit the FACT tables. This includes the EVENT as well as the MONTHLY snapshot. You may also need to modify the logic of the "ACTIVE/INACTIVE" flag...as this is what is used to calculate the headcounts. Essentially, edit the SDE to bring in the NED FLAG, and then modify the logic for how OOTB "ACTIVE/INACTIVE" is calculated.
2. If you are running reports that use EMPLOYEE DImension, and you want to also see if the Employee is NED or NOT NED, then yes, you should also add this to the Employee Dim. Also, suppose that an employee can BECOME NED...if you need to capture this history, then you need to add the SCD logic. Also, if an existing employee can become NED..you may have to alter the incremental logic to modify both the DIM and the FACT.
What may be simpler is just to modify the SDE mapplet to use the LOOKUP for NED..and flag those as INACTIVE in the SDE itself...in which case you do not have to modify the downstream ETLs.
Hope that helps. Pls mark correct or helpful.
When you refer "What may be simpler is just to modify the SDE mapplet to use the LOOKUP for NED..and flag those as INACTIVE in the SDE itself...in which case you do not have to modify the downstream ETLs", are we referring to SDE of Dimension or of Fact?
At the moment, i only need these FLG as part of metric calculation, not as dimension attributes, so can i assume you were referring to SDE, SIL of Workforce fact process?
Thanks in advance,
If you only need the metric, then just the FACT. Essentially, find the FLAG that is used to calculate the "Headcount" downstream and edit the SQL in the SDE mapplet.
Pls mark as Correct if this is helpful. Thanks.