The NQQuery.log file also indicates the user who executed the analysis, the timestamp, and the OBI Connection Object used for the analysis. Self-Service means that , business users can design their own reports based on their needs. The execution of the view objects and view must be based on the Logical model code to render the measure or attributes executed in the request. If the user does not have the proper privileges, log in to Presentation Services as a user with administrator privileges and navigate to the Manage Privileges page to assign the proper privileges to the user. To access Presentation Services and check the privileges required to access reports, perform the following steps: An error may have occurred when Oracle BI Publisher connected to Presentation Services. The names of duty roles that grant access to subject areas include the words Transaction Analysis Duty (for example, Workforce Transaction Analysis Duty).

By default, this option is disabled for OTBI. This section contains the following topics: View the Presentation Services Logical Query In the Log, View the Logical Query In Presentation Services. Perform this step to ensure that your system is secure. Caching is turned off by default for the Oracle Transactional Business Intelligence (OTBI) content to ensure the OTBI analyses always return real-time data. For more information, see section Setting the Query Logging Level in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition. Some of the OTBI reports maybe switched to run against OBIA. There is also a set of APIs that allow retrieval of BI Publisher data in non-Cloud code. Oracle Enterprise Manager Fusion Applications Control.

OTBI is a Oracle Transactional Business Intelligence reporting tool. BI Publisher can be used as an alternative reporting solution to OTBI. OTBI REPORTS IN ORACLE FUSION. See Caching Options in Oracle Transactional Business Intelligence (OTBI) for information about how to enable caching. Do not edit the properties for aliases if the source view object property has already been changed. In most cases, Presentation Services fails because the BI Server is not running. Its provide you real time and Self-service reporting solution in Fusion. BI Publisher is more favorable for technical users and when the desired result is not a report, but data. However, it is possible for users to override this account. Business users with appropriate roles can use Oracle Fusion Transactional Business Intelligence to create analyses that support decision-making. The SQL Bypass database should be set up in the repository to send the physical query to the database directly, rather than through the ADF Server. I have already explained the OTBI Subject folder and My Folder in Details in my last post. When troubleshooting, check if the Data Warehouse Enabled profile was set to Yes, No, or NA.