Bhaskar Konar

It'll be very useful feature to have.

in Allow for Custom Palettes to be saved across all workbooks Comment by Bhaskar Konar Sep 9, 2024 8:11AM

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

in How to build an Analysis on OTBI to show every colleague's default expense account? Comment by Bhaskar Konar Apr 17, 2024 6:20AM

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

in Add custom dashboard to procurement home page Comment by Bhaskar Konar Nov 2, 2023 10:47AM

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,

in Need to restrict OTBI report prompt values based on the user logging in Comment by Bhaskar Konar Jul 26, 2023 1:02PM

Upvoted.

in Auditing Reports to capture changes to the Permissions of the BI Catalog objects Comment by Bhaskar Konar Jun 14, 2023 8:05AM

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…

in Not Able to Apply Multiple Values to Prompt in Formula Comment by Bhaskar Konar May 26, 2023 7:48AM

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

in Detailed log for OTBI Agent Comment by Bhaskar Konar Mar 24, 2023 3:42PM

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

in Detailed log for OTBI Agent Comment by Bhaskar Konar Mar 23, 2023 8:57AM

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

in OTBI Export to Excel or CSV limitation Comment by Bhaskar Konar Mar 17, 2023 5:19PM

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

in Detailed log for OTBI Agent Comment by Bhaskar Konar Mar 1, 2023 11:52AM

Fully agree with you. Thank You very much Jahnavi! @Jahnavi-Oracle Cheers,

in Detailed log for OTBI Agent Comment by Bhaskar Konar Oct 27, 2022 12:05PM

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,

in Can you get data from data model or report (not analysis) thought web service (XmlViewService) ? Comment by Bhaskar Konar Mar 30, 2023 12:51PM

Glad it worked & you liked it. Appreciate your time @Shubham Shree.

in Can we change the color of Graphs? Comment by Bhaskar Konar Mar 28, 2023 7:20PM

Hi @Shubham Shree, Yes it is possible. Here are the steps for you. Follow the highlighted in Yellow. Hope this help. Cheers,

in Can we change the color of Graphs? Comment by Bhaskar Konar Mar 28, 2023 7:16PM

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,

in How to count employees in department? Comment by Bhaskar Konar Mar 28, 2023 8:28AM

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,

in How to query fusion tables in SQL developer Comment by Bhaskar Konar Mar 27, 2023 11:40AM

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,

in OTBI Report Performance Issue Comment by Bhaskar Konar Mar 27, 2023 8:52AM

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,

in How to open OTBI on phone application Comment by Bhaskar Konar Mar 24, 2023 4:33PM

Hi @mickel rmeily, Can you please check for Oracle HCM Cloud, Oracle Analytics etc? Hope this help. Cheers,

in How to open OTBI on phone application Comment by Bhaskar Konar Mar 24, 2023 11:35AM

Hi @mickel rmeily, Please find below documentation which might be useful for you. How Can I View Analytics with a Mobile Device? - Release 11.1.6 (oracle.com) Cheers,

in How to open OTBI on phone application Comment by Bhaskar Konar Mar 24, 2023 10:17AM

Welcome to the Oracle Analytics and AI Community

Bhaskar Konar Rank 9 - Analytics & AI Expert

Comments