Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 57 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 53 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
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.
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
Thanks!
Joy Hanneman
Code Snippet
SET VARIABLE DISABLE_RIGHTTRIM_FOR_VARCHAR=1, DISABLE_RIGHTTRIM_ON_LENGTH_FOR_VARCHAR=1;
Tagged:
0
Comments
-
Moved to OBIEE forum.
0 -
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 last0