Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Extract Data with HTML formatting

Received Response
62
Views
4
Comments

Hello Experts,

I need your assistance regarding fetching data with HTML formatting in the OTBI Report.

Currently, I'm working on the 'recruiting - recruiting real time' subject area. I'm attaching the XML and the screenshot of the HTML text. I added external and internal job posting details, and as per the requirement, I need both fields with their HTML formatting.

If anyone has an idea how to achieve this target, I would be thankful to you.




Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 4 - Community Specialist

    I tried to use the column property option, but it doesn't work.


  • Rank 7 - Analytics Coach
    edited Feb 20, 2024 10:03AM

    Hi, In the column property option did you change the data format to HTML?


  • Rank 4 - Community Specialist

    Yes. The output looks like this.



  • Rank 4 - Community Specialist
    edited Feb 21, 2024 5:55AM

    @Nathan CCC Thank you for your response. I can set the HTML formatting on analytics, the same as we have on the Job offer by using the 'Plain Text (don't break)' option.

    But still, I failed to achieve the target they need both external and internal HTML formatting in .XML file and this formatting is not showing in the .XML output file.

    At that point, I failed to extract data in HTML formatting.

    If anyone knows the solution please update.











    XML Output looks like this.

    Thank you.

Welcome!

It looks like you're new here. Sign in or register to get started.