Skip to Content
0
Former Member
Feb 27, 2009 at 07:10 AM

Two Requests in ODS

47 Views

Hello,

I'm loading from two source systems into an ODS.

The data is to be passed on to a cube.

The request of source system 1 is taking days to load. In fact no data has arrived yet in BW (still selection on R/3 database).

The request of source system 2 has already arrived in BW. However it cannot be activated in the ODS because the request from source system 1 was created first (lower request ID).

I get the message:

Req. X in DataStore X must have QM status green before it is activated

Even if you set the QM status to green, the system would still not allow you to activate an ODS request if not all previous requests are activated as well.

My plan is to activate both requests, even though the other request is still running.

SS1 hasn't arrived in BW yet. And it will probably fail, due to the request being activated in the ODS.

My hope is that the data will be loaded into the PSA even though the request has been activated in the ODS. I could then pick it up from the PSA later on.

Does this sound like a feasible approach to you or rather not?

Many thanks for your advice.

Gerrit