Dynamically Retrieving Dates in Oracle OTBI with TIMESTAMPADD
The TIMESTAMPADD function is an indispensable tool for Oracle OTBI developers working with dynamic date calculations.
View details Articles
Tobi Y.
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.
View details 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.
View details 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.
View details 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.
View details 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.
View details 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.
View details 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.
View details 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.
View details Using @INLINES in your BI Publisher RTF Template
BI Publisher RTF templates support powerful markup commands to control data rendering, formatting, and logic in output documents. One advanced command is @INLINES
View details