export multi-period to a file

Summary:

export of multiple periods to a file via data management

NOTE - the is PBCS outputting to a FILE not the other direction.

Content (please ensure you mask any confidential information):

So I'm trying to create a data management rule to export from PBCS, the only reason for making this a data management thing and not a report is I need to pipeline the output to an sftp location. (So if anyone knows a simple way to sftp a file on a timed basis from EPBC without using epm automate or other middleware then please share!!)

So my problems are; -