Oracle Fusion #21: How to Create Analysis - First OTBI Reports

-- Oracle Fusion Video Series : Video 21

#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant

Join Our Telegram Group:
https://t.me/techtalkswithnaresh

FOLLOW US :
============
YouTube :    / techtalkwithnaresh  

For More details Contact Us:

Email: [email protected]
--------------------------------------------------------------------------------------------------------------------------------------------------------------
In this Playlist I had uploaded all the videos which help you to learn the Oracle Fusion BI Reports and Oracle Fusion OTBI Reports which will help you to improve your skills. If you have any doubt's regarding any of the uploaded videos you can write in comment section. If you need more videos on other topics in Oracle fusion you can reach out me at [email protected]. Please do like, share and Subscribe the channel to get latest videos.

How to Create Analysis - First OTBI Report

1. Difference between Bi Reports and OTBI reports

BI Reports: SQL_QUERY -- Select_Columns -- Layout -- Run -- Output
OTBI Reports: Subject_Area -- Select_Columns -- Layout -- RUN -- Output

Advantages of OTBI over BI:
1. Functional consultant can build the OTBI report.
2. Oracle has already the pre-built subject areas. Just we have to create Analysis.
3. We can built the OTBI report for SCM,CRM, Finance, etc.
4. We can create the Dashboard using OTBI.

Disadvantages of OTBI over BI:
1. We can't do custom report.
2. We can't built any custom Subject Area.

Navigation for Catalog: Tools -- Reports & Analytics -- Browse Catalog -- Catalog Page.

Steps to create the OTBI Report:
1. Navigation : New -- Analysis
2. Go to Payable Invoice Transaction real time.
3. Select the required columns.
4. To test the output format while creating the report click on result tab in left section.
5. For Running the report go t catalog and click on open.