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,

Thank you very much @Sahithi Kolasani-Oracle & @Gaurav Bharadwaj-Oracle ! Appreciate your help. Cheers,

Hi @Palak Karma , It seems you're using BY clause outside of Aggregation Function. Your code has been changed a bit and now has no syntax error. Can you please check this one? ( SUM(CASE WHEN CAST("- Purchase Receipt Line Details"."Creation Date Line" AS DATE) < CAST("Purchase Order Schedule Detail"."Need By Date" AS DATE)…

Hi @Tom Buechler , As per my understanding currently no log is available in OTBI Cloud version which is not helpful at all. I've raised the following in the idea lab. Please have a look and feel free to vote if you like the idea. Detailed log for OTBI Agent — Cloud Customer Connect (oracle.com) Hope this help. Cheers,

Hi @ashrestha01 , I'm not sure about your exact requirement but please find below some OOTB Components that are available. Hope this help. Cheers,

Hi, Is that schedule being executed by the Recipient? if Yes, then it might be the security that's restricting the data. When you say the file is having 38K record who is executing that? Ideally ask the recipient to execute the report directly to see how many data they are getting. Hope this help. Cheers,

Hi @Ankit.Mahajan Glad it worked & solved your problem. Would you mind accepting the answer that solve your issue? It'll help the fellow community members in future. Thank You. Cheers,

Hi 55Chevy, Firstly print the column without any formatting and then check if you can see distinct values in the timestamp or not. If all the values are same in timestamp part then probably the column is not holding the correct Timestamp values and there's no point of doing the formatting. If it does hold unique values…

Hi @Ankit.Mahajan Probably you need to enable the download data options for that Report in the Dashboard Page. Please find below steps. Edit the Dashboard Page --> Go to the Section where the Report exists Click on ‘XYZ’ as highlighted below. Click on ‘Report Links’. Click on ‘Customize’ and then select ‘Export’ Save the…

Hi @Brennan , Can you please check the following note? Is there anything similar that can be explored ....? Document 2137038.1 (oracle.com) It might not be solving your issue but thought of double checking. Cheers,

Hi Max (@Max W) Glad you are able to fix it and you liked it. Cheers,

Hi Max, (@Max W) Please find attached document which might be useful. Can you please try the following? Use Double Column to Create Language-Independent Filters: Oracle Cloud applications store data in multiple languages. Hard-coding text string in a filter creates a problem with multi-lingual data. OTBI uses Double Column…

Hi Eva, Measure values can't be Suppressed in tabular view. Try with Pivot View. Hope this help. Cheers,