Story Reports – Combine Holiday and Timesheet data without a direct query relationship

[skusulja]

Hello everyone,

I am building a monthly Timesheet Story Report in SAP SuccessFactors Report Center, based on the Recorded Time Data (V2) query.

Goal:
Generate a monthly timesheet per employee, showing all attendance and absence types — with columns such as:

• Date
• Start Time
• End Time
• Quantity in hours
• Time Type (working time, vacation, sick leave, holiday, etc.)

Problem:
The Recorded Time Data (V2) table does not contain entries for public holidays.
The Holiday data exists separately and can only be reached through the User → Employee Information → Job Information path.
However, when trying to connect those datasets in Story Reports, the query expands uncontrollably — generating huge amounts of redundant data, to the point where nothing meaningful can be displayed or analyzed.

I have checked all other available query tables and possible combinations — there are no tables that can directly connect or combine both employee timesheet (Recorded Time Data) and holiday information in a way that provides usable, consistent data.

Additional context:

• No Time Tracking license → cannot use Time Valuations.
• Absence Counting Configuration is not useful for this case.
• I only need this for reporting (not payroll integration).

Questions:

1. Is there any supported way to bring Recorded Time Data (V2) and Holiday data together into the same Story Report?
   For example, can this be achieved if I add both tables as two separate data sources, where the only common field between them is the Date column (without any direct relationship through Employee or Job Information)?
2. Can I use any formula or calculated column in Recorded Time Data to identify or return Holiday dates?

Any ideas, workarounds, or model design suggestions would be highly appreciated.

Thank you in advance!