Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to handle CLOB datatype in OBIEE reporting?
we have a requirement where data is in XML format with the length of around 22000 character in 1 of the column of the table which is getting used for the report.
Answers
-
Lots of resources on the internet on that, for instance:
https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-reporting-on-clobs-lookups/
Or
0 -
Are you looking to display the clob contents or have individual columns reflect the content of individual xml elements from within the clob?
0 -
Hi Thomas,
we need to display the clob content in the report.
0 -
4 links with the solution plus there are working examples in the SampleApp VM which you can just look up and use. Are you looking for something else? Or is this question answered?
0 -
Hi Christian,
i have already gone through the 4 links before posting the question here.
I am not sure the question is answered or not but i am not able to implement it yet
0 -
So you just want to dump the raw XML to the screen? If so, then the links provided guide you to being able to do just that ... if you want columnar representation of xml elements that's a different approach.
0 -
What prevents you from implementing the steps provided by the links?
0 -
+1 to both Thomas and Martin
So what are you EXACTLY trying to do and what EXACTLY is preventing you from making it work?
0