Hi Team,
How do I convert comma separated values to columns in OTBI Report.
For eg- We have created a multiple select choice list field and data is showing in comma separated values in a row. We need to convert it into columns in OTBI report.
Is the CSV data coming in from a file or held in a database table field?
Can use instr to search for the comma and substr to extract the data between located comma's. Is the data free text i.e. is it possible that the text contains commas as part of the text entry?
It is a multi select choice list which we have created. If a user has selected multiple values for that field on the UI, then it is showing value in report separated by comma.
It's been a while, trying to picture what you mean, in the past I've read the selections into a variable and combined using a filter
Hi @User_UL61Z, Could you please provide the solution for this. We are trying to implement something similar to this
Hi, any solution for this?
Can you please provide a screenshot showing what is the current vs expected output with one example
We have the same requirement. We have an invoice description that contains critical references that we need to display in separate columns. The invoice description is one column in OTBI. How do we get it to separate out into a column per data item as separated by commas.
I would suggest using locate and substring formulas.
Uses locate function to find position of the comma, then use substring function while using the position # from locate.
Similiar to: https://community.oracle.com/customerconnect/discussion/585089/otbi-locating-5th-occurrence-of-character-using-substring-and-locate?utm_source=community-search&utm_medium=organic-search&utm_term=locate+substring
Very helpful information.
Thanks for sharing @Rich Merkel!
Hi @Rich Merkel that worked and thank you
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
