OTBI Report with SQL query filter
Summary:
Hi Team,
We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report.
Could you please confirm if this level of customization is supported in the Fusion HCM SaaS product?
Appreciate your guidance.
Content (please ensure you mask any confidential information):
We have a reporting requirement (OTBI) that requires us to implement custom SQL logic which integrates Organization Tree hierarchies with User-Defined Tables (UDTs) that store LE for OTBI analyses and dashboards.From what we understand, OTBI is based on predefined subject areas and does not natively allow for:--> Direct SQL execution within OTBI.(Direct/Indirect)