Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

REQUIREMENT : NEED TO FETCH SECOND SEGMENT FROM AF Holding Limited.Facilities Management - Retail.Unspecified.Credit card receivables.Unspecified.Unspecified.Unspecified.Unspecified.Unspecified SOLUTION IN OBIEE/OTBI : SUBSTRING("- PO Charge Account"."Code Combination Description" FROM LOCATE('.', "- PO Charge…

in OBIEE extract string from between 2 characters Comment by Niharika Paramkusam-Oracle Aug 19, 2022 11:43AM
Hi Team, how can we fetch text between two characters in OBIEE the above example is relevant to me but it fetching extra characters. If you (Joe Choueiri-Oracle, Gianni Ceresa) got any resolution from mentioned above please guide me. I am trying to fetch description of second segment from below : AF Holding…

in OBIEE extract string from between 2 characters Comment by Niharika Paramkusam-Oracle Aug 19, 2022 8:22AM
I am also looking for the same requirement, please let us know if we have any query from where we can get the details of all the reports in the instance

in How to get the list of all custom reports in OTBI Comment by Niharika Paramkusam-Oracle Nov 8, 2022 5:50AM