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…
Check out our tutorials on OTBI to become a pro at creating reports and analyzing business data. Improve your skills, impress your coworkers, and contribute to the success of your organization. Join us on this learning journey!
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.
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;
Cross subject area analysis – OTBI
In this article, we will discuss on how to report on multiple subject area in OTBI The following are the rules to be followed to create a multiple subject area…