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.
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
URLs – Oracle HCM Cloud
set of URLs, to easily access technical components such as UCM server, BI Server, OTBI dashboards, XMLP Server links, BIP report links, GO URLs All these URLs to be memorized and/or bookmarked by every Oracle HCM Cloud - Technical Consultant needs.
how to auto refresh a dashboard – OTBI 101
OTBI dashboard shows a run time snapshot of data from cloud, which becomes stale after sometime, as and when the users try and create data. So, to update the dashboard end user should always refresh the dashboard. In this article, we will see how to auto-refresh an OTBI 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.
how to get list of HCM extracts scheduled by a user
best practice is to schedule HCM Extracts using a service account. To know if there are any HCM Extracts scheduled by a non-service user, follow the instructions in the article.