Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Extract Data with HTML formatting

Received Response
63
Views
4
Comments
Saher
Saher Rank 4 - Community Specialist
in Oracle Transactional Business Intelligence

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.

recruiting - XML.txt


image.png


image.png


Tagged:

Answers

  • Saher
    Saher Rank 4 - Community Specialist

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

    image.png


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

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

    image.png


  • Saher
    Saher Rank 4 - Community Specialist

    Yes. The output looks like this.

    image.png


    image.png


  • Saher
    Saher 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.

    image.png


    image.png










    XML Output looks like this.

    image.png

    Thank you.