cancel
Showing results for 
Search instead for 
Did you mean: 

Email failure notifications for existing reports

Former Member
0 Kudos

Hello,

I am a systems analyst who doesn't run any type of reports myself - I was asked by my department to take over a project, and am pretty much starting from knowledge base zero, so any and all assistance would be greatly appreciated.

I was asked to develop a system of failure notification for existing reports. From what I have searched online and through the SAP discussion portals, such notification can be specified on the report level, but due to the current volume of reports in our BO system, it sounds as if going through and specifying email notification on each report would not be a viable solution. I have also read that this type of "global" request is best addressed through an SDK, but I am unaware of where to start with that. I noticed that there was both a .NET SDK and Java SDK subgroup and I did not know if one platform would be more suited than the other to address, or if the platform used relies on how the BO system is set up. I was given access to a test server which is running BusinessObjects BI Platform 4.1 SP6. I thought there might be a way to find out where a report is given the status of "Failure" in the Content Management Server database and somehow glean the connected report information from there, but was having trouble finding which table that might be in or if that is even a meaningful direction to go in.

As I said, I am flying somewhat blind when it comes to the framework of the BI platform, so please let me know what further information is needed. Even a point in a specific direction, I feel, would be greatly beneficial to me in my current position. Thank you for your time and any help you can offer.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

As you are not familiar with SDKs, the best place to start from would be the developers guide available at http://help.sap.com

Navigate to Analytics --> SAP BusinessObjects Business Intelligence --> SAP BusinessObjects Business Intelligence Platform --> SAP BusinessObjects Business Intelligence Platform 4.1 --> Development Information, and refer to the guides ' Business Intelligence platform Java SDK Developer Guide 4.1'


Direct link for download are available below

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_bip_java_dg_en.zip

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp6_bipjava_apiRef_en.zip


The developer guide has the required steps on how to start using the SDKs, and the jars required to run the sdks.


As far as your requirement goes, it is similar to code available at the below SAP article.

http://service.sap.com/sap/support/notes/1741585


Thanks,

Prithvi



Former Member
0 Kudos

Thank you for your prompt response and direction.

When I click on the final link in your post < http://service.sap.com/sap/support/notes/1741585 > it opens a Windows Security window stating server 'websmp230.sap-ag.de' is requesting a user name and password, and it doesn't appear as if my SAP Community credentials are being accepted. I do not get an error message after I hit OK - it just blanks out my password entry and will load a blank page if I hit Cancel. Are there separate credentials (or separate security settings) needed to access the service.sap.com links? Thank you again for your time.

Former Member
0 Kudos

You would need an 'S' user ID credentials to access the link. The credentials are required to access the contents on SAP Service Market Place.

Attached is the code which can be used to enable email notification for failed instances. You might need to test the sample with a sample report to validate the results.

Thanks,

Prithvi

Former Member
0 Kudos

This is great! One quesion - how does jsp get triggered to run and send the mail?