To Automate Process Chain Monitoring

[Former Member]

Hi All,

Currently we have process chain which extracts data from Informatica system and loads to BW DSO's.

After successfull execution of process chain daily, we download data from PSA, and display only company code, reference key and data packet.

We make a Pivot table in excel sheet to display only company code, refreence key and data packet.

When I plan to automate it, I have a problem. I have all data with PSA table (company code, reference key & data packet).

But I need to display data daily after execution of process chain. So the date is not getting captured with PSA table.

Can you please help me on the same.

Thanks.

[Former Member]

I think for displaying the 3 fields on a daily basis, you need to select the request based on date and then filter out the fileds using a select query in your code.