Hi David From NQSQuery.log, Please review the physical Query generated for the Prompt and review the logic used.

Hi David Glad to know the issue is resolved. Thanks & Regards Rajasekhar

Hi Upload a screenshot with detailed navigation steps that shows the details.

Hi Sandhya Please add ESS Administrator & ESS Monitor roles to the user. After that Run the ESS Scheduled process: Import User and Role Application Security Data" to reflect the changes. Then logout and re-login and validate the results.

Hi Sushant Please try the below In the Criteria tab—>Select the required date column—>Click on Filter—>select the check box "Convert this filter to SQL"—>In the Advance SQL text box enter the SQL as per your requirement and save the analysis. Refer to the given help centre documentation link

Hi Sushant There is no option available to pass parameters while scheduling OTBI agents. This is expected behavior. As an alternate solution, Please hard code specific filter values in the OTBI analysis before scheduling the OTBI agents. Refer to the help center documentation about Agents.

Hi David Please review SQL Query generated by OTBI analysis using NQSQuery.log. Fusion Applications: How to Get nqquery Using Manage Session (Doc ID 2225909.1) Using the BI Publisher data model create a dataset using SQL Query and check the data available in the underlying database tables.

Hi Welsey Please review the given Help Centre OTBI subject area documentation link Review the Special Considerations section Note:This subject area uses the ESS job "Refresh BI Reports Audit Data for User Adoption Reporting" to summarize and aggregate data used for user adoption reporting.

Hi JML BI Author role access users can able to create and schedule an OTBI Agent. Please verify the details using the below navigation login into BI Application with BI Admin role user—>Click on Administration—>Navigate to Manage privileges—»Navigate on Create Agents and verify the roles assigned.

Hi Dona Please try to use presentation variables. Refer to the given help center documentation link

Hi Paul Please refer to the given tutorial link https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ps/ps.htm

Hi Dilip Please review the given documentation link Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (OTBI) (Doc ID 1567672.1) https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/combine-subject-areas-analyses.html#GUID-8B9DF9B1-20E3-4F88-8EEE-0714EF6E2F63…

If you want to cancel the OTBI analysis long-running report then do the following. Login into the BI application with BI Admin user-->Click on Administration-->Click on Manage sessions-->Search for the analysis report-->Click on Cancel Running request. If it is a BIP report executing in an online model then you will get an…

Please try to use the concat option to merge both column's data. Refer to the doc https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/edit-formulas-or-calculated-measures.html

Hi BICC VO's are seeded and cannot be customized. Please review the above-given Database lineage mapping details and identify the VO name based on the database tables.

Thank you for your idea

Yes this is useful

Password protection is a Good idea.

While creating the Schedule, Select "Make Output Public" to make this job output available to all users with permission to access that specific report. Users with access can view the report from the Report Job History page.…

Rest API's are not currently supported. Please review the below documentaiton about the available webservices Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1)