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,…

Hi @AjayKumar Maddipati, Please find below steps to get the filter conditions in each analysis that have been used. Click on Highlighted in Yellow in above step. Click on Highlighted in Yellow in above step. Hope this help. Cheers,

Hi @AjayKumar Maddipati, It is possible to do that row wise. You have to use the Pivot table. I was trying with your sql but it seems you have few DFFs which are not present here, as a result I'm not able to modify your report. If you have a simpler version without any DFFs then please attach the report xml so that I can…

Hi @Shubham Shree, Yes it is from OTBI. I've attached the Report XML in my previous post. If you use that you will be able to see the logic and details. Hope this help. Cheers,

Hi @Shubham Shree , It's possible. Please find attached sample XML. You can extend as per your requirement. It's giving me following results. XML - Performance Goals.txt Hope this help. Cheers,

Hi Trent, Here's query where you can specify the Segment1 select * from GL_CODE_COMBINATIONS where code_combination_id in (selectdistinct default_Code_comb_id from per_all_assignments_m where person_id in(select person_id from per_all_people_f))AND SEGMENT1 = 'Specify SEGMENT1_NAME/NUMBER' Hope this help. Cheers,

Hi Trent, Yes that can be done. I was just giving you a sample query. If we remove the filter on Person Number it'll bring everybody in one go. select * from GL_CODE_COMBINATIONS where code_combination_id in (selectdistinct default_Code_comb_id from per_all_assignments_m where person_id in(select person_id from…

Hi @Trent M, It seems default expense account is not available within OTBI Subject Areas. Here's a not from Oracle. Default Expense Account In OTBI Report (Doc ID 2492612.1): Document 2492612.1 (oracle.com) Alternatively you have to build a BI Publisher Report. Following query might be useful for you. This is stored in…

Hi @Brennan , Glad you are managed to resolve the issue. Appreciate the detailed insight. Thank you very much. Cheers,