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.

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,