BI publisher Bursting FTP/SFTP
Hello to All,
I've a problem using the FTP bursting to create a spool of file (one file for each country in my case) into a directory.
I'm usign the code below to use the burst but I get a generic error.
select distinct
COUNTRY_CD as "KEY",
'Graph_1' TEMPLATE,
'RTF' TEMPLATE_FORMAT,
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
'SFTP' DEL_CHANNEL,
'wiki.ifad.org' PARAMETER1,
'country-briefs' AS PARAMETER2,
'zfRLOO2IKsi7OmMz' AS PARAMETER3,
'/upload' as PARAMETER4,
COUNTRY_CD||'.' AS PARAMETER5,
'true' AS PARAMETER6
FROM
DWH_PS_FIN.CP_CONTRIBUTIONS_SUMMARY
where COUNTRY_CD='AFG'
Anybody has a suggestion to underline the mistake in the query?