I have tried unchecking , still generating these characters in the front for each row.
Hello Ramani, Is the snippet you shared from the XML file or the output file when scheduling the report? Thank you Hassan
Output file
Welcome to Oracle Analytics Community.
Can you share a screen shot from output to show how it looks? Normally this will be a template issue rather than a DM issue. Please check your template once.
Thanks.
Hi Mandeep,
Agreed, it's just template. It was working fine before and I just made one small change and upload again. I have removed few elseif's. that's the only change I did.
If TermDate IS NOT NULL and Asg_Action <> ‘GLB_TRANSFER’
Then
If Termination_Reason = 'ADMIN' Then 'ADM'
Else If Termination_Reason = 'ATTENDANCE' Then 'ATT'
Else If Termination_Reason = 'FAILED_DRUGS' Then 'FDT'
Else If Termination_Reason = 'LAYOFF' Then 'LAY'
Else If Termination_Reason = 'MISCONDUCT' Then 'CON'
Else If Termination_Reason = 'UNSATIS_PERF' Then 'UNS'
end if
Try the below:
Suppress Blank Lines with <?if:condition?>...<?end if?> Use inline formatting like:
<?if:FIELD!=''?><?FIELD?><?end if?>
Check the below:
Setting Report Processing and Output Document Properties
Hi Ryaz,
Thank you for the suggestion, the template has lot of if statements, when I applied to the one I made changes it didn't work. I have done modification to the original one again very carefully and it worked this time in development and crossing fingers it will work in Production.
Thanks for the update. So, possibly the issue was due to incorrect update of the template.
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for https://community.oracle.com/customerconnect/kb/articles/1-accepted-answer
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
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.
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.
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…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
