Hi Please review the given help center documentation link about Null values in Views https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/suppress-null-values-views.html Also, To try hide the column please try the below Edit the Pivot table view—>Click on Column Properties—>Hide the column as per your requirement.

Hi Thank you for the details. Please try the below for group by clause Example:sum("Procurement - Purchasing Real Time"."Purchase Order Header Detail"."Purchase Order Amount" BY "Procurement - Purchasing Real Time"."Supplier Profile"."Supplier Name")

Hi Please provide us the below details for our review a) catalog using the archive option b) NQSQuery.log of the report. Follow the below steps Doc ID 2225909.1 Fusion Applications: How to Get nqquery Using Manage Session

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Please review the given cross-subject area guidelines. https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/combine-subject-areas-analyses.html#GUID-8B9DF9B1-20E3-4F88-8EEE-0714EF6E2F63 When the report build with more than one subject areas, things to consider You should have a common dimension in all the subject areas…

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 https://docs.oracle.com/en/cloud/saas/sales/faoec/User-System-Usage-SA-147.html#User_System_Usage_SA_147_d1e52553 Review the Special Considerations section Note:This subject area uses the ESS job "Refresh BI Reports Audit Data for User…

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 https://docs.oracle.com/cd/E23943_01/bi.1111/e10544/prompts.htm#CIHBEEIF https://docs.oracle.com/en/cloud/saas/taleo-enterprise/23d/otbou/c-usingvariables.html#id20130115120033363

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…