How to call Fast Formula in BIP report .

Summary:

Hi Team,

We are trying to call Fast Formula outputs directly inside a BIP Data Model SQL query using the WITH FUNCTION + FF_EXEC approach.

However, we are facing blockers with our specific formula types:

1. Timecard Calculator formulas — require ELEMENT_ENTRY_ID and PAYROLL_RELATIONSHIP_ID contexts which are only available during a Payroll Run. When called from BIP, these return 0 and the formula immediately exits with an error.
2. Time Calculation Rule formulas — require HWM engine contexts (HWM_FFS_ID, HWM_RULE_ID etc.), use array-type inputs/outputs, and call multiple child formulas — none of which are supported by FF_EXEC.