Can I precalculate a BEx query and email the results as an attachment?

[Former Member]

We are on BW 3.5, currently pulling data from R/3 4.6C (but upgrading to ECC 6.0 in mid-July). I have been successful (once, once I was able to talk my email administrator into letting a .js file through) in sending an email, but the results are in HTML in the body of the email. I need to send the results as an Excel spreadsheet attachment. From all of the SAP documentation I've read, it seems this should be possible, but I haven't been able to make it happen. It seems to ignore the setting in the Broadcast scheduling screen. I've tried it with both "Execute" and time-based scheduling.

Many thanks for any documentation, pointers, or magic tricks.

[former_member181887]

Hi,

In addition to Eddy's reply, do you have the precalulation server installed?

You will need to install/configure the precalculation server which handles the pre-calculation of the excel workbooks. It needs to be installed on a windows server that has excel installed. http://help.sap.com/saphelp_nw04/helpdata/en/fc/420d40854ee569e10000000a155106/frameset.htm

Cheers,

Mike.

[eddy_declercq]

Hi,

This can be done via Information Broadcasting.

Pls check

http://help.sap.com/saphelp_nw04/helpdata/en/a5/359840dfa5a160e10000000a1550b0/frameset.htm

For Bi 7

http://help.sap.com/saphelp_nw70/helpdata/en/a5/359840dfa5a160e10000000a1550b0/frameset.htm

Eddy

-

---

PS. Reward useful answers and earn points yourself