Trailing Spaces in OBIEE
Summary
formatting questionContent
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.
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.
Tagged:
1