General OBIEE

Get Involved. Join the Conversation.

Topic

    Joy Hanneman
    Trailing Spaces in OBIEE
    Topic posted October 30, 2019 by Joy HannemanGreen Ribbon: 100+ Points, tagged BI Publisher, OBIEE Answers, OTBI, Reports, SQL 
    30 Views, 2 Comments
    Title:
    Trailing Spaces in OBIEE
    Summary:
    formatting question
    Content:
    Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish.

    I have a report where I need to create trailing spaces and have fixed character length columns. I have leveraged casting as VARCHAR, overriding the default value to plain text (don't break spaces) and using the prefix in the advanced tab of

    SET VARIABLE DISABLE_RIGHTTRIM_FOR_VARCHAR=1,

    DISABLE_RIGHTTRIM_ON_LENGTH_FOR_VARCHAR=1;

    I'm still not getting the results I am expecting. When I export it no matter the file type, its still trimmed and the trailing spaces are gone.

    Do you know what I am doing wrong?

    I really appreciate any advice! I haven't had much luck with the knowledge database and using on site resources to get this figured out.
     
    The specificity of this formatting is due to a file we are sending off to a vendor where they have fixed character length columns included in the requirements.

    Thanks!

    Joy Hanneman
    Code Snippet:

    Comment

     

    • Julian Challenger

      Moved to OBIEE forum.

    • nathan morgan (at Client)

      Here is a not very elegant way of getting a fixed length string (10) by concatenating non breaking space character 160 to the end of the string... 

      select all 0 s_0
      , substring(cast("Expenses - Expense Transactions Real Time"."Time"."Calendar Year" as character)||repeat(char(160),10) from 1 for 10) as s_1
      from "Expenses - Expense Transactions Real Time"
      order by 1 asc nulls last, 2 asc nulls last