Much needed and it will add so much values. Upvoted. Thanks @Lee Eslick-Huff!

Thanks for sharing @SERGIO BARRETO! Much appreciated.

Very informative & useful information. Thank you very much @Mallikarjuna Kuppauru-Oracle & @Ram-Oracle!

Very interesting; looking forward for the session. Thank You!

Hi @Abhi_19, If you are not able to achieve your requirement using multiple SAs, you can try using Logical SQL. Here's a quick example or high level steps that will help you to understand more: Consider your existing Report (should be having the a Primary Key like INVOICE_ID) As DataSet1 and then create another report…

Hi @Abhi_19, Please find below the Best practices that need to be considered while developing a report using more than one subject areas. You should have common dimension in the subject areas used in the report. Add at least one Measure/Fact/Metric from each subject area on the report. Click on the Advance tab of the…

You can use an OTBI Report as a Data Model. There are 2 ways to do that. Directly calling that Report. Use the Logical SQL of the Report in the Data Model. If you want to overcome the OTBI Limitations of 25K (in Excel) or 75K (in CSV) data, then you can use any of the above method and it will also follow the OTBI security…

It'll be very useful feature to have.

Hi @Karen Wilson, Please find below SQL with Assignment Number: SELECT ppf.person_number, ppnf.display_name, pf.assignment_number, pf.assignment_status_type, pf.default_code_comb_id, glcc.segment1, glcc.segment2, glcc.segment3, glcc.segment4, glcc.segment5, glcc.segment6 FROM per_all_people_f ppf, per_all_assignments_m pf,…

Thank you very much @Anders W. Langholm! Appreciate your help & detailed insight. Cheers,

Hi @Sharmava, Please use the following SQL which will make sure the security in place. SELECT "Position"."PER_POSITIONS_DFF_B_N_2DN_RG_STRCTR_" FROM "Workforce Management - Worker Assignment Real Time" WHERE "Worker"."User Name" = VALUEOF(NQ_SESSION."USER") Hope this help. Cheers,

Upvoted.

Hi @User_8IP5M, Can you please try the following to see if it is resolving your issue or not. FILTER(FILTER("Premium EAS"."Total Collected Premium" USING ("Policy"."Owner Issue Age" <= 40)) USING ("AppSigned Agent"."AppSigned Agency Name" IN ( @{BM_AGENCY}['@']{'Sample Agency'} ))) / FILTER("Premium EAS"."Total Collected…

Thank you very much @Murthy Kodavati! Please up vote if you like this idea so that Oracle might consider. Cheers,

Fully agree with you Bobby. Hope Oracle will consider. Thank you very much! Cheers,

This idea could help a lot and it's much needed. 25K is very low for Spreadsheet especially with Finance Data.

Hi @Gary Miller-39965, Very well said, fully agree with you. Thank you very much! Cheers,

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.