Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

BIPUblisher (11.1.1) removes extra spaces, I need the extra spaces...

Received Response
272
Views
7
Comments
Carlos Diazzamora
Carlos Diazzamora Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

BIPUblisher (11.1.1) removes extra spaces, I need the extra spaces...

Content

Hello, we have this report that runs a store procedure that returns one single column with extra spaces in between in order to make it fixed size but the BIPublisher removes all the extra spaces. Is there a way correct this behavior?

Examples

Data in SQL developer:

ELEMTN1   ELEMENT 2 

ELEMT2     ELEMENT 2

ELEM3       ELEMENT 2

Reading that table in BIpublisher:

ELEMTN1 ELEMENT 2  

ELEMT2 ELEMENT 2

ELEM3 ELEMENT 2

Thanks,

c

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    What template are you using?  RTF, Excel, Interactive?

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Try putting the element inside a table.

  • Gladys Calvozamora
    Gladys Calvozamora Rank 2 - Community Beginner

    Thanks Sherry George, it did worked.  I had my RTF template wrong before.

  • Gladys Calvozamora
    Gladys Calvozamora Rank 2 - Community Beginner

    I'm using a BIP layout.

    But the issue started in the data model.  I create a new data model with a simple SQL Query: Select 'hello      world' from dual

    In the data model, when I go to the View tab, and try to see the resulting data, BIP has already delete the blank spaces.

    Thanks,

    Gladys

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Did you try what I suggested?  I was able to see the spaces in my test.

    RTF output

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    What is your template type? try using an rtf template and see if it resolves the issue.

  • Gladys Calvozamora
    Gladys Calvozamora Rank 2 - Community Beginner

    Sherry George, I have this same issue.

    Everything starts in the data model. I'm using a SQL Query, is very simple.  Then the column type is String and it automatically deletes the blank spaces.

    For example:

         In the SQL Query I put:                               Select 'hello      world' from dual

         When I see the data it looks like this:           'hello world'

    What I need is that BIP do not delete the blank spaces.

    If you have any suggestions, I will really appreciate it.

    Thanks,

    Gladys