Skip to Content
avatar image
Former Member

How to Export file with dynamic name ( ex:- system date) from SAP BPC MS

Sep 15, 2017 at 02:03 PM | 67 Views | Last edit Sep 20, 2017 at 01:50 PM 3 rev.

Hi,

I need to create an automatic job to export files with unique names ( Ex:- system date_name). The job will run once every night. Essentially, I would like to have a package run, where it will title the exported .txt file as DDMMYY_Export, where the date will change, and the files will not overwrite prior day files.I can not see any option in data manager to do this until i am missing something. Can someone please help.

Thx

Sam

SAP Business Planning and Consolidation, version for the Microsoft platform
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Dipal Patel
    Oct 24, 2017 at 09:50 PM

    Hi Sumit

    There might be an option to modify "Export" Data Manager package, which i do not know.

    The easy way to achieve your requirement is to modify filename after "Export" Data Manager package completes. You can use either Command scripts or SSIS package to do this and automate this task.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Dorra KHEZAMI
    Oct 29, 2017 at 10:15 AM

    Hi Sumit,

    As far as I know there is no standard feature in BPC MS packages to so this.

    You will need probably to create your own package SSIS (custom one) with visual studio.

    Regards

    Add comment
    10|10000 characters needed characters exceeded