cancel
Showing results for 
Search instead for 
Did you mean: 

Read PSA and Update data targets in BW 3.5 using the Prcoess Chain

Former Member
0 Kudos

I am looking for ideas, I have one infopackage that brings the delivery data from the data source into the PSA level and feed one ODS. From the successful request in the PSA level I need to update three more ODS and two infocubes. As of now the process is manually done, right click from the infopackage in the PSA and select the three ODS and two infocubes and schedule the update. In the process chain, I have one infopackage that brings the delivery data from the data source into the PSA level and feed one ODS. Then, I am using Read PSA and Update data target, it locates the PSA table and the data target which is great. But the problem is it only offer to use or to select the object type - request or infopackage, with the request how could I tell to look for the successfull one sitting in such PSA table. If I use the infopackage how could I specify to look for the data siiting in the PSA...Thank You for any ideas how to handle it.

Accepted Solutions (1)

Accepted Solutions (1)

nvytla
Participant
0 Kudos

Use option "PSA and Data Target sequentially" in InfoPackage, then two process will be available in Process Chain (Load to PSA, Subsequent to Target). Connect first to second on "Sucess Only". Process Chain will take care of dependancy.

Eventhough data loading to two different targets, due to source is same you will get the delta only once.

Hope it helps,

Naveen

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

If we generally think infopackage is an intermediate between source and target.

Now if the source has so many targets to feed data in it will have the data targets in the infopackage and you can mention or check mark only the targets required by you

Hope this solves ur problem.

This can be done with the process chain it has many process types and among them is scheduler which is the infopackage thus use this and schedule it as per the requirement.

Former Member
0 Kudos

Use the object type as infopackage and in the infopacke only check the target that requires updation in the first step.

The above step ensures to update only succesfull request to target.

If any further targets needs to be updated later, use the followup action to link next variant as succesful.

Hope this helps.

Naveen.A

Former Member
0 Kudos

If I use the infopackage option which contains already the data source 2LIS_12_VCITM to different data target, It would repeat a delta load into BW again. I could create a new one but could i specify that the data source is the successfull request siting on such PSA table.

Former Member
0 Kudos

Thanks Naveem. What do you mean with the following up actions?

Former Member
0 Kudos

By follow up action he meant that the process types that get associated to a process type by default ...

Like when we load data to ODS , ODS Activation gets associated with it be default

Amit