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.
Hi @Ivony Ann Paula Salango ,
Extra Spaces or Characters. These often come from:
Concatenated columns with manual spacing. Hidden HTML tags or formatting in text columns. Null values being replaced with placeholders.
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 Ali
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.
We have built an OTBI report intended for Line Managers to view their subordinates’ emergency contact details. The report uses the Workforce Management - Person Real Time subject area. When a Line Manager runs the report, the emergency contact fields (e.g. EC Phone Type, EC Phone Number, EC Email Type and EC Email Address)…
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…