Skip to Content
avatar image
Former Member

Automate Data manager Package - Load from BW to BPC - Time Variable - How to pass variable values

Hi All,

I am loading the transnational data from BW to BPC by manually selecting the time period. Is there anyway I can automate the time variable. Now I manually select the time period when I execute the DM .Is there anyway to derive the time period based on the system date ? I want to automate this by deriving the time period values based on the system date.

I can see it can be done through the UJD_TEST_PACKAGE and prompt file.Like update the UJFS file once a month when ever the job is executed.

Is there any ABAP BADI's exist to do this or any other solution to pass the variable in the DM package based on the system date ?

For example : I enter 2017/012 for time period in DM package. I want this 2017/012 has to be derived based on the system date automatically when ever the job executed monthly.

Thanks in advance for the help and much appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 24, 2017 at 07:56 PM

    I have answered this question number of times - WHY NOT TO SEARCH?

    Very short answer:

    Create a copy of UJD_TEST_PACKAGE like ZUJD_TEST_PACKAGE

    In the abap code read the system date and fill table LTH_ANSWER_PROMPT with correct values including Time period from system date.

    Create chain with ZUJD_TEST_PACKAGE

    Run it!

    Another option is to use VBA to pass answer prompt from Excel: https://blogs.sap.com/2017/06/16/simple-vba-function-to-pass-parameters-to-dm-packages/

    Add comment
    10|10000 characters needed characters exceeded