Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, August 26, 2019

Fusion OTBI - Oracle Fusion Transactional Business Intelligence Reports Training Manual


With Oracle Fusion Transactional Business Intelligence embedded analytics, role-based dashboards, and on-the- fly ad hoc reporting capabilities make data access and interpretation easier than ever before. Users are able to see updates in real-time, and their impact, through embedded analytics. For example, during the compensation budgeting process, a manager is able to see a running tally for reference right on the page. This eliminates the guesswork with dashboards that deliver in-line information while you do your work. Pre-delivered operational reports are enriched with robust and flexible ad hoc query capabilities that access real-time transactional data – no need to push data to a separate warehouse or engage the IT department for a custom report: it is easy, and right at your fingertips

Business Intelligence Composer
The Business Intelligence Composer is a simple-to-use wizard that allows organizations to quickly and easily create, edit, or view data without requiring an engineering background. With this capability Human Resource organizations can build and deliver reports that the business needs whenever they need it, without waiting for IT support. It is built for the business user.

Real Time Ad Hoc Query
Traditional ad-hoc reporting solutions require a person to have deep domain in their subject area and an understanding of data objects in the relevant tables they needed to report from.
OTBI hides that complexity and transforms the 9000+ reportable data objects into everyday business terminology. Which means if you are looking to see a worker’s average performance rating you will find the reporting object named as “Worker’s Average Performance Rating”.
This is all done by using the standard Oracle query and reporting tool (OBIEE). OBIEE has end user tools (Answers, Dashboards) to provide an easy-to-use interface for business users to perform current state analysis of their business applications. Constructed queries and reports are executed real time against the transactional schema supported by a layer of view objects.

In OTBI, business users can also easily drill on predefined hierarchies, enable action links, compose a dashboard, schedule a report or dashboard for delivery and export data or reports to a variety of file formats. Fusion users can also easily embed an OTBI report or dashboard in a Fusion page through Personalization

Integrated with Fusion Applications
OTBI is fully integrated with Fusion applications (roles, flex fields, lookups, trees). There is no need for additional implementation steps to map security or provide configuration inputs. OTBI needs minimum setup and is ready for use once Fusion Applications are configured and installed.


We are going to develop the Below OTBI reports
1. Navigating to and Viewing a Standard Report
2. Creating Custom Report with Wizard Template
3. Creating Custom Report with Custom Template
4. Creating Analysis Reports for Suppliers
5. Creating Ad Hoc Reports for Expenses


1. Navigating to and Viewing a Standard Report
Select Reports and Analytics under Tools in the Navigator.






































Please click on the below link for more details:

Fusion OTBI - Oracle Fusion Transactional Business Intelligence Reports Training Manual


Please Like and Share our FaceBook page to get more details on Oracle Applications

1 comment:

Sayed said...

Thanks is very good for the beginners

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect