Referring to the following OTBI Interview question and answers on Oracle Fusion Technical, you would be able to get more information on simple and advanced level interview questions.
Q1. How to create Oracle Fusion OTBI Reports?
Ans: Following steps required to build new OTBI report from the scratch
- Login To Fusion Applications with a User login
- Click on the Navigator icon and then select ‘Reports and Analytics under Tools option.
- Click on the BI catalog icon (an open book) on top left hand side.
- Choose New Analysis from the drop-down list and then select an appropriate Subject Area (Workforce Management – Worker Assignment Real Time, for example).
- Now you would select one folder from left-hand side, inside table folder will find tables respective columns, will drag and drop required column to the dashboard to create the OTBI report.
Q2. What is OTBI Report?
Ans: OTBI is the Oracle Fusion monitoring method, which is used to generate oracle cloud files. OTBI is the most user-friendly method used in oracle fusion, where we can use drag and drop options to create the files. It does not need the skills of SQL and the awareness of Fusion tables to create the report. It is the really useful method for separating the data from the framework used in Oracle Fusion.
Q3. What are the Features of OTBI?
Ans: Oracle Fusion Transaction Business Intelligence (OTBI) is a real-time self-service monitoring solution provided to all Oracle Fusion product customers with a legitimate role in generating ad hoc insight and analysis to help them make their decisions on a daily basis, following are the main features of OTBI
- User Friendly
- Speedy development of reports
- Powerful Data Visualization
- Minimal SQL required
- Security configuration is fully integrated with Oracle Fusion
- Provides real time analysis of Transactional data
Q4. What is Logical and Physical SQL in OTBI?
Ans: Logical SQL: A logical SQL is exactly similar to a physical SQL. BI Server understands logical SQL
Physical SQL: The physical SQL is the one that is sent from BI Server to the data sources in order to retrieve data
Oracle BI Server transforms the logical SQL into physical one through a process known as query processing that can be understood by source database
Q5. What is My Folder and Shared Folder in Fusion Reports?
Ans: My Folders is your own folder. It means it is specific to each user. when you will create your report under this folder then no one in the application can see and access these reports because these are saved and created under your My folder. so this is totally yours personal Development.
Shared Folders is your Application Common Folder. It means it is shared across users of the application as per the roles. Shared folders have many Sub-folders related to the Work related and Module Related.
Q6. Can we use multiple subject area in OTBI report?
Ans: Yes, you can use multiple subject area to build OTBI report but make sure those subject area should have one dimension otherwise OTBI report will not work.
Q7. Can we create new subject area for OTBI report?
Ans: No, you cannot create new subject area, you can use Oracle predefined subject area.
Q8. How user can access OTBI report, does it require any roles to be assigned?
Ans: BI administrator role is giving access to OTBI reports, we assign multiple roles to user and within those roles BI Administrator roles are interlinked, therefore user can access OTBI report from their existing assigned roles.