You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trailing Spaces in OBIEE

17
Views
2
Comments
edited Oct 30, 2019 8:04PM in General Transactional Reporting (OTBI) 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!