Using for-each@section: for Accurate Page Numbering
Using for-each@section: with Microsoft Word’s native page numbering fields is a best practice for multi-section BI Publisher reports requiring accurate, reusable page counters.
Details
Using Extended Functions in Oracle BI Publisher: Choose, When, Otherwise vs. If
This post discusses the use of conditional statements in Oracle BI Publisher. We will discuss IF Statements and also the Extended Functions: Choose, When, Otherwise
Details
Using Default Date Parameters in Oracle BI Publisher
Using Default Date Parameters in Oracle BI Publisher Oracle BI Publisher allows you to set default date parameters dynamically in your report data models, making reports adaptive and eliminating the need for manual date input each time the report is run. These dynamic defaults empower automated scheduling and streamline user experience. Common Default Date Functions Here are…
Details
Making the Most of Date-Related Variables in Oracle OTBI Reports
Date handling is a cornerstone for accurate, timely analytics. Utilise OOTB repository and session variables to dynamically reflect data against calendar periods
Details
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.
Details
Dynamically Retrieving Dates in Oracle OTBI with TIMESTAMPADD
The TIMESTAMPADD function is an indispensable tool for Oracle OTBI developers working with dynamic date calculations.
Details
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.
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.
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.
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.
Details