How to report on data from Workforce Assignment Event Real Time and Workforce Assignment Real Time

Summary:

We have a requirement to report historical employee headcount based off values stored in an Assignment DFF. We get accurate historical data only when an action is processed in the year we're reporting on.

We need a solution to provide accurate reporting from both Workforce Assignment Real Time and Workforce Assignment Real Time

Content (please ensure you mask any confidential information):

n/a

Version (include the version you are using, if applicable):

n/a

Code Snippet (add any code snippets that support your topic, if applicable):

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

  0 s_0,

  "Workforce Management - Worker Assignment Event Real Time"."Time"."Calendar Year" s_1,