OTBI Report with SQL query filter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Report with SQL query filter

edited Aug 26, 2025 1:24PM in Reporting and Analytics for HCM 3 comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!