Transactional Data load automation

[Former Member]

Hi all,

We load transaction data from BW for last 2 months. Now with change in month we have to manually go and update the values.

How can i automate it so that the values get updated dynamically and there is no human intervention. As from what I know there is no ABAP exit on Data Package Manager with which I can update the values.

I was looking for options to achieve full data load automation. Just FYI, delta load wont work in our scenario.

Thanks,

Devang.

[former_member200327 · Accepted solution]

Hi Devang,

There are multiple ways to do this. One is to build a Virtual provider on top of your BW cube and restrict in Transformation to last 2 months.

Another is UJD_TEST_PACKAGE that reads ANSWERPROMPT from UJFS. You can update that UJFS file with a custom program.

There are probably other options. I'd think that preferred way depends on the skills in house.

Gersh

[Former Member · Accepted solution]

Hi Gersh,

We have multiple BW cube from where we load data into BPC so building virtual provider will be little much of development effort.

I was hoping for a solution which can be taken care in BPC. Can UJD_TEST_PACKAGE option be used with package links.

Can you please share the link?

Thanks,

Devang.

[former_member200327 · Accepted solution]

Hi Devang,

There is a different program UJD_TEST_PACKAGE_LINK. Unfortunately this program can't take Answer Prompt from File Service. So, I'm not sure if you can do it with Package Link.

You can arrange these ABAP programs in a Process Chain and either schedule it directly or call from a DM Package.

Gersh