Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle table
Summary:
We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Desired Hourly Rate/Salary field, tto the report. The Extra Info fields are not in any recruiting subject area in OTBI.
I understand that the Extra Info field are on the roads map for the first half of 2026. However, we need to report on it now and would prefer not to writer the entire report as a BIP report.
Is it possible to have an field within an OTBI report use sql (on that field only) to query the oracle table directly? If so, does anyone have an example to share?