BusinessObjects job reports output format different from SAP BusinessObjects Central Management Console (CMC).

Document ID : KB000087860
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

When the output option ‘tab separated values’ is selected on a SAP BusinessObjects job defined against the RA BusinessObjects Agent the results display in the csv file with double quotes around them as shown below.
 
"ID_INTERNO_PE","NUM_SEC_AC","COD_RL_PERS_AC","NUM_RL_ORDEN","FECHA_CRRE","COD_ECV_PERS_AC","COD_ACTIVO"
"208576581","350509522","01","0","2015/02/10 00:00:00","3","MO"
"924774133","350509522","01","1","9999/12/31 00:00:00","2","MO"
 
This is because SAP’s REST API that Automic is using doesn’t have the same text qualifier options available as are available from SAP’s CMC.  So when the ‘tab separated values’ option is selected SAP’s BusinessObject’s REST API sets the default to a double quote instead of setting the output to the desired format in plain text without the quotes such as this:
 
STARTLOAN-PERS                                                                        
ID_INTERNO_PE               NUM_SEC_AC    COD_RL_PERS_AC            NUM_RL_ORDEN               MI_FECHA_FIN  COD_ECV_PERS_AC
1093328              4220820299        01           1             31/12/9999         2
1946464              4237549313        01           1             31/12/9999         2

We do have a workaround available for those customers running the RA BusinessObjects Agent from the Automation Engine, which is basically to run a Post Process script that will strip off the quote characters from the report.  A Word document outlining the setup for this workaround is attached to this Article as well as well as 2 sample report output files showing the data before running the Post Process script and after.
Cause:
Cause type:
Other
Root Cause: According to SAP, only the ‘ and the “ are approved values within the RESTful SDK, which is what Automic is using for their RA BusinessObjects Agent. SAP stated that the RESTful SDK is not yet at full parity with what the CMC/BI Launchpad is able to do.
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Version(s):
In order for all the output delimiter options to be available in Automic’s RA BusinessObjects Agent that are available in CMC/BI Launchpad, SAP will need to add those output delimiter options to their RESTful Web Services SDK
Additional Information:
Workaround :
Refer to Description.
File Attachments:
AE Workaround.zip