Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Data Formatting in BIP Report
Summary
Data Formatting in BIP Report
Content
Hi,
We have a report in which the database column is a varchar2(4000) field which has very long text. Data is stored with tabs and carriage returns:
AAAAAAAA. AAAAAAAAAAAAA.
AAAAAAAAAAAA,
AAAAAAAAAA
When I do a select in Toad and cut paste the sql output onto textpad, I can clearly see the carriage returns and tabs. But in the report its coming like the following, like one long continious string.
AAAAAAAA. AAAAAAAAAAAAA. AAAAAAAAAAAA, AAAAAAAAAA
How can we bring it into the report just not as a single line but like how we see it in database.
Thank you so much.
Answers
-
How is the data appearing in XML and what is the template type ?
0 -
Sherry,
Thank you for responding.
1. We used BI inline layout. We did not use any templates.
2. XML data is coming like a continious string.
0 -
I did try a test in my local(Oracle BI Publisher 11.1.1.9.0, Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ) and the formatting was fine with carriage returns. Though I did find a similar issue documented by Oracle in the following document.
Oracle Support Document 2109719.1 (OBIEE 11g: When Running An Analysis Answer In BIP All HTML Formatting Is Lost) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2109719.1
0 -
So it looks like the issue is with how the source data is coming into BI publisher. What is the data model, is it a sql query or something else ?
0 -
Its sql.
I m uploading the xml data and the sql out of how the data is stored in the database.
Thank you.
0 -
Ok. If you have the add-in for MS word could you create an rtf template, load the same XML and preview the report. If not you can just create a .rtf document with the data element tag like <?A?> and upload the template and then run the report to see if the formatting is appearing.
0 -
Now I understand whats happening:
1. If I open the xml file in notepad++ it is showing me the carriage return.
2. If I doubl click and it gets opened in browser, the formatting is getting lost
I think when it comes to layout, we are losing the formatting.
Can you pls double click your xml and see if you still see the formatting?
Thank you.
0 -
Do you want to see the xml file?
Can I export an xml file here?
0 -
That is weird. Could you do a test, for the above same test data.
1. Login to BI publisher
2. Create a data model using the test data (used above).
3. Export the data from the data tab and attach here.
In other words do not try to create a report but just create a datamodel and export the data (no need to save the data model).
0 -
Yes I could see the formatting in the XML. See below. What you could try is, in your SQL replace html tags in the varchar column with corresponding ascii (like chr(10) for carriage return) and see if the formatting is retrieved in XML.
0