How to Set Variables in Oracle OTBI for Enhanced Report Control

Setting variables in OTBI empowers report developers to tailor report execution by dynamically controlling a report or simply producing finer logging for debug purposes.

Dynamically Retrieving Dates in Oracle OTBI with TIMESTAMPADD

The TIMESTAMPADD function is an indispensable tool for Oracle OTBI developers working with dynamic date calculations.

Mastering the FILTER Function in OTBI for Advanced Data Filtering

This blog post provides a comprehensive guide for OTBI users looking to leverage advanced filtering techniques with the FILTER() function.

Tracking Custom Reports and Detecting Folder Changes

Monitor your custom reports and their folder structure and incorporate this into your regular maintenance tasks to keep your reporting environment organised.

Leveraging Flexfields in Oracle Cloud ERP BI Publisher Reports

Using Flexfields in BI Publisher enables you to present both granular segment data and business-friendly concatenated displays, bridging operational detail and executive insights in every report.

Reporting on Change Records in Oracle HCM Using EXTRACTVALUE on XML_DATA_CACHE

Parsing contents of HRC_TXN_HEADER.XML_DATA_CACHE using EXTRACTVALUE to report on detailed change data captured during transactional events in Oracle HCM.

Passing Multiple Values to a Parameter in Oracle BI Publisher

Oracle BI Publisher supports parameter types that allow users to make multiple selections, enhancing the flexibility and usability of reports.

Using SUBSTRING and LOCATE for Powerful Data Parsing

In OTBI, key flexfields codes are often stored as concatenated strings separated by dots or other delimiters. Extracting individual segments from these composite fields is essential for flexible reporting.

Logical SQL for Cross-Subject Area Joins and Self-Joins

OTBI provides powerful ad-hoc reporting capabilities, but sometimes business requirements call for analyses that are not directly supported by the out-of-the-box subject area.

HCM OTBI Effective Date Reporting in Oracle Cloud

Leverage the parameter PARAM_EFFECTIVE_DATE for effective tracking of headcount, employee movements, and key business metrics.