Oracle Analytics Cloud and Server

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

Format issue in Report

Received Response
2
Views
4
Comments
SwapnaPrerana
SwapnaPrerana Rank 3 - Community Apprentice

Hi Experts,

In Database the data is stored as following.

  • Point 1

          # Sub Point 1

          # Sub Point 2

  • Point 2

          #  Sub Point1

          #  Sub Point 2

In Obiee, when I drag this column into report, all the points are coming in a single line.

  •      Point 1 # Sub Point 1 # Sub Point 2  etc

can you please suggest how to keep the same format in report as like in Database.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Not sure I'm getting what you're saying. Are you stating that the text in your DB is stored with line breaks, bullet points and everything?

  • SwapnaPrerana
    SwapnaPrerana Rank 3 - Community Apprentice

    Yes Christian. In DB its coming Line Breaks, Bullet Points etc. I want to maintain the same in OBIEE, but its not happening (Coming in a straight line). I can't put you the screenshot. Else I would have.

  • SwapnaPrerana
    SwapnaPrerana Rank 3 - Community Apprentice

    May I know if any suggestions on this.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Not many ideas from my side - analytical usage of data normally isn't as strict with how strings get represented.

    If you manage to get your data converted into a format which holds all information (data, formatting etc) in a HTML-interpretable form then you can show it in a text column containing HTML content. It's a web app after all so in the end all gets interpreted by a browser.