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.
Automation – Bulk password reset
Your organization acquires a new company. All the employees to be converted to new company and user accounts to be created. bulk user creation can be done through HDL. However,…
4 ways to export dashboard to excel – OTBI 101
3 possible ways to export an OTBI dashboard to excel. 1. Export to excel using standard layouts - Manually select Page Options on the Dashboard page toolbar, select Export to Excel, and then Export Current Page, Export Entire Dashboard 2. Export to excel, using a custom export layout - create a layout to use instead of standard layouts 3. Use Agents to deliver a dashboard page as Excel format. 4. Create a OTBI analysis and design its layout according to the desired excel layout/format. Include a link to this analysis in the main dashboard
Hide a Section in OTBI – OTBI 101
Select a section you want to hide Go to format section -> expand Additional custom CSS style write display:none;
Report Time Zone and Date issues – BIP 101
Reports display the time according to the time zone preference selected here. You can override this setting when creating a scheduled report job. Note that the time displayed on the user interface and reflected in report processing times is governed by the BI Publisher server time zone.
PGP encryption in Fusion BI Publisher
Are you inclined to use HCM Extracts feature, just because it has features like output file encryption, built in SFTP integration point then think again... if your main goal is…
Pagination in BI reports
Pagination is a technique to limit the no of records shown per page. for example, 100 records are fetched from the database or Oracle HCM Cloud, report output should split…
Sample HDL files for Work schedule Assignments
In this article, we will go through steps to create and manage work schedule assignments using HDL Goal HDL files to create work schedule assignments for employees Solution ScheduleAssignment.dat file…
Fusion BI – Useful queries
I am maintaining a repository of the code snippets/templates/queries, that I feel useful for whoever is working on Fusion BI - Adhoc reporting. Logged in user details The user information…