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
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
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…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
