BPF Activity steps Autoamtion

[rvvprasad]

Hi Team,

We have implemented BPF for Legal Consolidation. Steps are as below.

1. Data Load

2. Controls Monitor

3. Consolidation

When we trigger BPF Data load activity it will execute a the data load package. Once the data load package is successful. We come back to BPF and click COMPLETE button manually to finish the first activity so that the second activity will trigger.

My question, is there any possibility that after data load package is successful...the BPF Complete step is automated without clicking on button manually in BPF. We want this step to be automated.

Please let me know the possible options to automate.

System Details:

BPC10.1 Standard with EPM SP 27

Thanks,

Prasad

[rvvprasad]

Hi Vadim,

Yes this is what i would like to know. Business don't want to monitor this job. They want this step to be automated. Like once Job is successful automatically the BPF step should be completed and it should proceed with next steps.

I am thinking this possible solution, like we fill the BPF status tables using a program and execute this program at end of the data load job process chain. Is this solution will work?? If so i would like to know what are all the tables which i need to execute.

Please suggest.

Thanks,

Prasad

[former_member186338]

To my mind it's a wrong way!

Data loading results has to be monitored to find strange things even if the package return success: for example only 2 records loaded instead of normal 2000 records.

Also data loading takes time and is running asynchronously. Not possible to interact with BPF...

[rvvprasad]

Thanks for your update. But concern is business they don't want to do monitoring work they want this step to be automated. Any suggestions would be appreciated.

Thanks,

Prasad

[former_member186338]

It's your professional job as a consultant to explain business that it's a correct behavior to monitor the results. Because next time when the things go wrong they will blame you!

[former_member186338]

"My question, is there any possibility that after data load package is successful...the BPF Complete step is automated without clicking on button manually in BPF" - but how the system will know that "load package is successful"?

[rvvprasad]

Hi Vadim,

Yes this is what i would like to know. Business don't want to monitor this job. They want this step to be automated. Like once Job is successful automatically the BPF step should be completed and it should proceed with next steps.

I am thinking this possible solution, like we fill the BPF status tables using a program and execute this program at end of the data load job process chain. Is this solution will work?? If so i would like to know what are all the tables which i need to execute.

Please suggest.

Thanks,

Prasad