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…

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)

For extraction of huge volume of data use BICC as an alternate solution. Review the below documentation link https://docs.oracle.com/en/cloud/saas/applications-common/20d/biacc/

Hi Currently Rest APIs are not supported in Fusion SAAS BIP application. Please review the below documentation link about available web services Doc ID 2086077.1 Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications

Hi Please follow the steps How to Add the BI Administrator Role to a user in Release 12. (Doc ID 2238277.1)

Please assign BI Admin role access to the user and then use archive /unarchive option and validate the results.