Broadcasting BEx Report in the form of Excel

[former_member210571]

Hi,

How to broadcast a BEx report in Excel (.xlsx) format through emails.

Regards,

Mirza

[RamanKorrapati · Accepted solution]

Hi Mirza,

Please check this.

http://scn.sap.com/docs/DOC-27867

http://scn.sap.com/docs/DOC-25391

Thanks

[former_member210571 · Accepted solution]

Hi Raman,

I have read the docs before. But in the doc there is a " Output Fotmat" : XML(MS Excel), while i am getting only the following output format.

[RamanKorrapati · Accepted solution]

Hi Mirza,

If we don't have output formate as Excel, then we need to go with manual, saving excel and sending thru email(think so).

Thanks

[former_member210571 · Accepted solution]

Hi Raman,

Is there any setting changes which we can make in order to get Excel in the output format.

Also executing a report, then saving it into excel and sending through mail is not recomended.

Thanks.

[RamanKorrapati · Accepted solution]

Hi Mirza,

Have you seen this link http://scn.sap.com/docs/DOC-25391

at 13th point its showing out format as xml(MS Excel).

Please check this link too(broadcasting work book excel)

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c088ae8b-0562-2e10-c4b5-b43095be6...

Thanks

[Former Member · Accepted solution]

1. Run your query in Bex Analyzer

2. Save as workbook on server

3. In the add-ins menu in Excel, select tools, bex broadcaster

4. Create broadcast configuration, ie give name, email type, assign recipients, select a server, etc.

5. Test with Execue button.

6. Finalize with creating a schedule using schedule button.

You can also get an excel-like broadcast by doing the same as above but with just a query instead of a workbook. Use XML as the email type, and when users receive it and open it, the xml data will be interpreted by Excel. 

Manson.

[former_member210571 · Accepted solution]

Hi Manson,

I am aware of this process of braodcasting the reports but all this broadcasting process are carried through "SAP Netweaver Portal", but in my case clients are not ready to configure the portal, so we are trying to broadcast the reports in excel format from t-code RSRT, where I am not getting the XML as an output format (screen attached previously).

So, my question is, is it is possible to broadcast reports in Excel format without using SAP Netweaver Portal?

[former_member182516 · Accepted solution]

Hi Mirza,

There is no need for Portal for broadcasting.

Yes its possible to broadcast the quereies reports with out portal. Let us know what version of BW you are using? You have the XML(Excel) option in BW7.x version.

Regards

KP

[former_member210571 · Accepted solution]

Hi KP,

We are using SAP BW 7.2 version and XML(Excel) format is not available in broadcasting.

(Please refer above for RSRT broadcasting output options snapshot.)

Regards,

Mirza

[Former Member · Accepted solution]

Hi Mirza,

I am facing the similar issue which you described. Did you got the solution? If so please let me know the solution.

Regards

Shankar

[former_member210571 · Accepted solution]

Hi Chintada,

I searched a lot but didn't find any solution to broadcast BEx Report in the form of Excel. So, we decided to go ahead by installing a Pre-Calculation server, through this we were able to Broadcast the report in the form Excel.

Thanks,

Mirza.

[Former Member · Accepted solution]

Hi Mirza,

Goto RSRT and select your query.

Then use the button "Java Web"  here your can make a broadcast with the options:

-MHTML

-HTML

-XML

-PDF

-Online

If u use the button "Abap Web"

-MHTML

-HTML

-Online

Regards,

Leo

[Former Member · Accepted solution]

Hi Leo,

Your reply makes more sense to me. We are using "Abap Web" for scheduling and that could be the main reason we don't get the XML ( Excel ) option.

Do you have any SAP document which differentiates the scheduling output between ABAP Web and JAVA Web? The document would help us a lot to decide on installing the JAVA Web.

Regards

Shankar

[Former Member · Accepted solution]

Hi Leo,

Your reply makes more sense to me. We are using "Abap Web" for scheduling and that could be the main reason we don't get the XML ( Excel ) option.

Do you have any SAP document which differentiates the scheduling output between ABAP Web and JAVA Web? The document would help us a lot to decide on installing the JAVA Web.

Regads

Shankar

[former_member440785]

Hello Friends,

I am also facing above mentioned issue, We dont have option output format as XML, How to get the output format as Excel(XML)

we are using SAP BW version : 7.0

Thanks,

Vinod.

[Former Member]

Hi Mirza,

In order to broadcast the workbooks created in Bex Analyzer, u need to install the Pre-Cal Server on any local machine and all the time it needs to be monitored if it is up and running.

To monitor the pre-cal server whether it is up and running, use the T-code RSPRECADMIN.

After Installing the Pre-Cal server only, u will be able to see the option Excel  in the broascasting settings.

Regards

Badri.

[former_member210571]

Hi Badri,

I am well aware of what you have said. I have mentioned that only.

Regards,

Mirza

[Former Member]

Hi Mirza,

Thanks a lot for your response.

We installed the Pre-Calculation Server but still the option XML ( Excel ) is not available.

FYI, we are using ABAP Web to schedule the reports. Is this the problem?

Regards

Shankar