Automate email notification when data package fails

[Former Member]

We have an transaction data load from BI to BPC using data manager. We have automated it to run once in a day by scheduling the data manager.

But this load some times fails when the master data maintainance is not done.

Can we send an e mail (with error message) to the user if the load fails for some reason. Presently, we need to go to the view status and find out the issue message.

Thanks,

Swetha

[raghu_ram · Accepted solution]

Hi Swetha,

I think this kind of feature is not available in BPC or else needs Customization. You can check SAP Idea Place at the below link https://cw.sdn.sap.com/cw/community/ideas to see if this kind of feature is there or not.

Regards,

Raghu

[former_member339201]

Hi Swetha ,

We have come across similar situation and I viewed the "HOW TO .. " document as well.

Our Package failed and we have to check the log every time by viewing the status in Data Manager Module.
If you have come across any solution during time please share.

Regards,
SHUBHAM

[former_member748144]

We have a BI process chain that loads the data from our BI source cube to a staging cube to the BPC cube.  We have used the new BPC MAIL process step to successfully notify us of the success or failure of the data package to BPC. 

[Former Member]

Thanks a lot for replying Rich.

I tried what ever you have told.

THe package executed successfully as expected. But, there is no mail trigger.

I guess there are some BASIS configuration settings to be done.

Can you provide me some document or link which tells about the back end settings to be done for email triggering.

Regards,

Swetha

[RichHeilman]

Yes, you basis team will need to set up the SAPconnect via transaction SCOT.

Cheers,

Rich HEilman

[former_member215589]

Hi Rich,

We have a scenario in BPC 10.0 NW in which we have created a custom BAdi and triggering it through DM package via Logic Script. We want to trigger email with the log as an attachment. But in the Email only Package log and Rejected list is beign send as an attachment. However, we are trying to send the Formula log in which all the details are beign captured.

Any clue how we can achieve this? Any inputs would be appreciated.

Regards,

Priyanka Singh

[Former Member]

Hi,

I was refering to the How to documetn - "HOW TO EMAIL A BPC DATA MANAGER LOG TO A TEAM - FILES".

Donu2019t we require any configuration settings for this? The document does not mention any thing about this. Please suggest.

Also, kindly let us know if there is any updated version of this as we are on 7.5 version.

Not sure how to reach "rich heilman" (author) directly. Rich, please suggest on above

Regards,

Swetha

[raghu_ram]

Hi Swetha,

I have seen the doc which you are referring to. There is no updated version for that document.

To the left hand side of the Doc. PDF, did you see that there are some attachments (Compressed Zip file) provided.

You can use the sample files provided in the attachment to test this task.

Regards,

Raghu

[RichHeilman]

Well, the HTG that you mention is specific to importing data and sending a mail to a team, instead of a specific email address. You could use this HTG as a starting point for your development of a custom process chain, but I don't think you need to do that. There should already be an "Email" process type associated with BPC. If you were to copy a process chain, for example the import one, and add the "Email" process type, this could potentially work. I would suggest looking at any of the standard data manager packages that might use this process type already, and see how to build out the data manager prompts as well.

Regards,

Rich Heilman

[Former Member]

thanks for the link raghu.