Fully agree with you. Thank You very much Jahnavi! @Jahnavi-Oracle Cheers,

Hi @maria.stanciu, Please have a look into the following use case & example which might be useful. A Practical Introduction to the OTBI and BI Publisher web services - ERPWebTutor Hope this help. Cheers,

Glad it worked & you liked it. Appreciate your time @Shubham Shree.

Hi @Shubham Shree, Yes it is possible. Here are the steps for you. Follow the highlighted in Yellow. Hope this help. Cheers,

Hi @Paul Younes, Yes it can be achieved easily. Please find attached a Sample Report XML. Please feel free to extend as per your requirement like Active Employees only etc. XML -- Dept vs EMP.txt Hope this help. Cheers,

Hi @maria.stanciu, It is not possible to connect Fusion Database with SQL Developer directly. Instead you have to use BI Publisher to query the Fusion Database. Please find below a note from Oracle which might be useful for you. Document 2556632.1 (oracle.com) Hope this help. Cheers,

Hi @Praveen Gollu-Oracle, You need to perform various steps. Please fine below a document which might be useful for you. Document 1999456.1 (oracle.com) Hope this help. Cheers,

Hi @mickel rmeily, If you are getting issue with configuring Oracle Analytics App, I would recommend you to raise with Oracle Support so that they can guide you and configure it successfully. Hope this help. Cheers,

Hi @mickel rmeily, Can you please check for Oracle HCM Cloud, Oracle Analytics etc? Hope this help. Cheers,

Hi @mickel rmeily, Please find below documentation which might be useful for you. How Can I View Analytics with a Mobile Device? - Release 11.1.6 (oracle.com) Cheers,

Hi @Ray Gupta, Can you please share some more details like which report you are trying to achieve this i.e. OTBI, BIP etc. What is the problem you are facing? Ideally in both OTBI or BIP you can put a filter to exclude an account. Cheers,

Hi @Sudheer YN, Oracle allows up to 1,000 IN list values in a SQL statement. It can be achieved with some work around. If you are using OTBI Report you can do an Union Report or use those conditions as OR filter to accommodate more than 1000 entries. If you are using BIP then you can use the OR condition as mentioned below…

Hi @Sudheer YN, Can you please try the following logic: * Create a Report to identify all the Products where you can use Product Family / Any Range search to identify all Products that will be required to be filtered on main report. It might be returning more than 1000 rows. * Now develop the main report where use the…

Hi @AjayKumar Maddipati, Have you managed to resolve it. Thank You!

Hi @AjayKumar Maddipati, I executed your xml without the DFFs and it is returning data for the 'Last Extended Date'. It might be a good idea to develop a small report with Requisition & Last Extended Date and then see if the data is visible and then adding other columns one after another to see which column is creating…

Hi @AjayKumar Maddipati, The field I suggested ('Last Extended Date') is coming from the table: IRC_OFFERS and the column name: EXTENDED_DATE which is matching with your BI Publisher Report. There's a chance that security or any other settings are restricting you to view the data in OTBI. If you attach the Report XML /…

Hi @AjayKumar Maddipati, Have you tried the 'Last Extended Date'? Please find below the navigation & SA details. Hope this help. Cheers,

Hi @AjayKumar Maddipati, Glad to hear that you found the information as useful and managed to resolve the issue. Please feel free to select the best answer so that it'll help fellow community members in future. Appreciate your time. Cheers,

Hi @Mike Burnett, Please find below steps that should solve your issue. After logging in click on the far right corner as mentioned in Yellow and then follow the steps. On Clicking 'My Account' Now click on 'Analysis Editor' drop down and select 'Default - Start on Results tab when editing Analysis' Now Press OK. Then…

Hi @AjayKumar Maddipati, Have you tired using Pivot Table and put the Rating Level Name in Measure and change the aggregation level as first / last / max etc.? If possible attach the report xml / catalog here so that it can be looked into more details. Hope this help. Cheers,