Include Oracle BI Publisher Reports in Dashboards
In OTBI dashboard, we can access reports that were created in Oracle BI Publisher. The report is embedded in the OTBI dashboard page, or you might see a link that opens…
Password protected excel output – BIP 101
In this article, we will see an worked out example, to generate a password protected excel output using BI Publisher create a data set to fetch data define output &…
OTBI – To Date calculations (YTD/MTD/QTD)
OTBI does not support TODATE functions. Similar functionality is obtained by writing complex TIMESTAMPADD functions. In this post we provide, a set of date functions to calculate Year-to-date, Month-to-date, Quarter-to-date filters of any selected year, using only TIMESTAMPADD function.