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,

Hi @Trent M, Glad you found it useful. Appreciate your time & patience. Cheers,

Hi @Trent M, Please find below query where I have included Assignment Status Type. Either you can download the full result set and then exclude those that you don't need using spreadsheet filter or just do the filtering in the SQL for the status that is required. SELECT ppf.person_number, ppnf.display_name,…

Hi @Trent M, Apologies for late response. Here is the query, please have a look SELECT ppf.person_number, ppnf.display_name, pf.default_code_comb_id, glcc.segment1, glcc.segment2, glcc.segment3, glcc.segment4, glcc.segment5, glcc.segment6FROM per_all_people_f ppf, per_all_assignments_m pf, gl_code_combinations glcc,…