OTBI in Oracle Fusion HCM — Five Tricks That Make Your Reports Faster and More Useful

 Oracle Transactional Business Intelligence (OTBI) is the self-service reporting layer inside Fusion HCM. Most users know the basics — drag columns, add filters, run the report. But these five techniques will significantly improve your reports.

Trick 1 — Use Repository Variables for Dynamic Dates

Instead of hardcoding a date filter, use a presentation variable or a repository variable like CURRENT_DATE. This means "last 30 days" stays accurate without manual updates.

Trick 2 — Add a Calculated Column for Tenure

OTBI does not have a built-in tenure column. Add it as a calculated measure:

TIMESTAMPDIFF(SQL_TSI_MONTH,
  "Worker"."Hire Date",
  CURRENT_DATE)

Trick 3 — Filter on Primary Assignment Only

Without this filter, employees with multiple assignments appear multiple times. Always add:

"Assignment"."Primary Assignment Flag" = 'Y'

Trick 4 — Use Narrate View for Management Reports

The Narrate view converts your OTBI table into a written summary — useful for executive reports where leadership wants prose, not a table. Enable it under View → Narrate on any analysis.

Trick 5 — Schedule Critical Reports as Agents

Use OTBI Agents to run heavy reports overnight and deliver results by email. This prevents users from running large reports during business hours and slowing the system.

Navigate to Catalog → New → Agent, set the delivery schedule, and link your analysis.

✦ Limit your OTBI analyses to a maximum of 15 columns for performance. Reports with 30+ columns often time out — split into two analyses and join them in a dashboard if needed.