Much needed functionality, it'll add so much values. Upvoted.

Very informative & helpful information. Thanks for sharing @Prasenjit_Thakur-Oracle!

Hi @Kavita Shah, Please take a look into the following Oracle doc if you have not already, it might be useful. Hope this help. Cheers,

Hi @Dimple-Nagesh-Support-Oracle, Very informative & helpful information. Much appreciated. Thank you very much! Cheers,

Thanks for the detailed info @David Granholm-Oracle! Much appreciated.

It'll be a great feature to have. Upvoted.

Hi @Mohamed Mohsen, You've to control the access to Data Model developer role. It should not be allowed to the end users if they have data view restrictions. It is primarily a get-way to the Database so if someone can get the access the can access all the tables that present in the database like secured or non-secured.…

Much needed feature which will add so much values. Upvoted. Another use case is the Pivot table having multiple measures columns and wanted to rename those grand totals columns accordingly but it seems it is not possible yet.

Hi @Omran Zeaiter, If you have multiple measures, it is not possible yet to rename them accordingly. Please take a look into the following Idea and if you like vote it accordingly. Hope this help. Cheers,

Very informative & Helpful information. Thanks for sharing @Aravindan Thoppe Santharam-Oracle!

Thank you very much @Benjamin Arnulf-Oracle! Great piece of info.

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