Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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