Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to retain report format after exporting to Excel?
Hello,
Upon extracting the report, the format of values in excel file have extra characters and extra spaces. Is there a way to correct the data upon exporting?
Report values
Exported values with special characters and extra space below.
Answers
-
Extra Spaces or Characters. These often come from:
Concatenated columns with manual spacing.
Try the below:
Hidden HTML tags or formatting in text columns.
Null values being replaced with placeholders.- Use TRIM() and REPLACE() functions in your OTBI column formula:
sql
TRIM(REPLACE("Person"."Display Name", CHR(160), ' '))
CHR(160) removes non-breaking spaces.TRIM() cleans leading/trailing spaces.
2. Date Format Issues
Dates may appear as serial numbers (e.g., 44348.10469) in Excel.Set a custom date format in OTBI:
Go to Column Properties → Data Format.
Choose Custom Format like MM/dd/yyyy.
Avoid using time zones unless necessary.Check below as it might be helpful:
Creating Analyses and Dashboards in Oracle Transactional Business Intelligence
OTBI Report Date Format changes when exporting to Excel — Oracle Analytics
Thanks,
Riyaz Ali0 -
Hi @Riyaz Ali-Oracle ,
The extra spaces turn out to be extra rows in the excel file. I tried to check any possible option in the properties, but they are not working.
0
