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
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?