[go: up one dir, main page]
Scribd
Upload
121 views2 pages

Notes Otbi Reports

Oracle Fusion OTBI Reporting enables real-time reporting on Oracle Fusion Applications by leveraging web services to communicate with transaction systems. It offers tight security integration and supports automatic key and descriptive flex fields' extension, eliminating the need to customize the reporting layer when new columns are added to transaction systems. OTBI allows creating reports and analyses by selecting columns from prebuilt subject areas for financials, HCM, SCM and CRM or writing SQL queries. Advantages include functionality for both technical and business users, and embedding multiple analyses in dashboards. A disadvantage is the inability to create custom subject areas.

Uploaded by

fffffo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
121 views2 pages

Notes Otbi Reports

Oracle Fusion OTBI Reporting enables real-time reporting on Oracle Fusion Applications by leveraging web services to communicate with transaction systems. It offers tight security integration and supports automatic key and descriptive flex fields' extension, eliminating the need to customize the reporting layer when new columns are added to transaction systems. OTBI allows creating reports and analyses by selecting columns from prebuilt subject areas for financials, HCM, SCM and CRM or writing SQL queries. Advantages include functionality for both technical and business users, and embedding multiple analyses in dashboards. A disadvantage is the inability to create custom subject areas.

Uploaded by

fffffo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Oracle Fusion OTBI Reporting

Oracle Transactional Business Intelligence (OTBI)


OTBI enables real-time reporting on Oracle Fusion Applications by leveraging web services to
communicate with OLTP systems via ADF Entity and View Objects. In addition, OTBI offers tight
security integration with the corresponding Oracle Fusion Application. With OTBI, there is no need to
worry about customizing the reporting layer whenever new columns are customized in the
transaction system as OTBI already supports automatic key and descriptive flex fields’ extension.
Oracle Fusion OTBI Reporting

Creating OTBI Report /Analysis:

Nav > Create> Analysis /Report


Report Sql query Select Layout Run the report OUT PUT
columns
Analysis Subject area Select Layout Run the report OUT PUT
Columns

Subject Area: columns that are provided by oracle which you want to put into a report

Advantages:

1. Oracle already provided prebuilt (standard ) subject areas we just need to create
ANALYSIS/OTBI Report as per business by selecting required columns
Financial
HCM
SCM
CRM

2. Functional And technical guys can work


3. We can create dashboard in which we can embed more than one ANALYSIS

Disadvantages:

1. We cannot create custom /New Subject area

Subject areas url

https://docs.oracle.com/en/cloud/saas/financials/18c/faofb/subject-areas.html#subject-areas

You might also like