11 Replies Latest reply: Aug 26, 2009 5:48 PM by Simon Turnbull RSS

Broadcast by E-mail in excel format

Elena Pintilii
Currently Being Moderated

Hi Experts,

I am trying to broadcast a workbook trough e-mail via Tr. Code RSRT.

Is there any way to broadcast the workbook in EXCEL format? Maybe CSV format? In Information Broadcasting I have only HTML, MHTML, and Online link for output formats.

I am using BI 7.0 SP21, SAP GUI 7.10 SP13, Excel 2007, and BEX 7.0 SP.9.

Please advice if there is a way to broadcast the workbook in Excel format. If i open the workbook in Bex, and then I hit Bex Broadcaster button, nothing happens.

Thanks!!

  • Re: Broadcast by E-mail in excel format
    Praveen G
    Currently Being Moderated

    >

    Elena Pintilii wrote:

     

    > Please advice if there is a way to broadcast the workbook in Excel format. If i open the workbook in Bex, and then I hit Bex Broadcaster button, nothing happens.

    > Thanks!!

     

    Your portal works fine ?

    Is it something to do with your Java stack ?

     

    Actually once you hit the "Bex Broadcaster" from workbook it should take you to broadcast settings (after logging with your id).

    There you get option for MS excel workbook.

     

    Edited by: Praveen G on Jul 16, 2009 5:45 AM

  • Re: Broadcast by E-mail in excel format
    Muralikrishnan E
    Currently Being Moderated

    Hi,

     

    Yes,you can broadcast a workbook in Excel format.

    Invoke the BEx Broadcaster,You can invoke this through Web Analyzer->Right click->Context menu or through BEx Analyzer Tools->BEx Broadcaster

     

    Open the workbook in BEx Broadcaster

    Create a Broadcast Setting and set the Output Format as "MS Excel Workbook" and Distribution Type as "Broadcast Email"

    Execute the Setting

    This will broadcast a workbook in Excel format to teh mentioned mail address

     

    Rgds,

    Murali

  • Re: Broadcast by E-mail in excel format
    Lavanya Jutla
    Currently Being Moderated

    hi,

     

    Excel option will available when you try to broadcast worbooks..

     

    You will need pre-calc server for it..

     

    On your open workbook -- click on tools on bex toolbar -- > Dsitribute workbook.

     

    refer OSS note - 760775 (Settings for information broadcaster

     

    Regards

    Lavanya

  • Re: Broadcast by E-mail in excel format
    Elena Pintilii
    Currently Being Moderated

    I have precalculation server installed. I am opening an workbook in Bex Analyzer and when I hit Tools-->Broadcaster...nothing happens.

    The precalculation server is installed and it looks green in RSPRECADMIN.

    What should I need to do to open the Broadcaster? Do I really need a portal installed to broadcast weorkbooks in excel format?

  • Re: Broadcast by E-mail in excel format
    Ioan Petre Danalache
    Currently Being Moderated

    Hi Friends,

    The posts made by Elena were made by me (from her computer). Now I have my own S-user.

    Finally we solved the problem and I will put here the steps that we made to broadcast workbooks (in excel format) by email.

    My landscape is like this: SAP BW 7.0, DB2 database, windows 2003 Server, SAP Gui 7.10 SP 14, Office 2003 and 2007 (the broadcasting works fine in both versions of Office), SAP BI 7.10.

    1. Setup SAP Mail via tranzaction SCOT.

    2. Install the latest patches for the Bex Analyzer (bi710sp09p_902-10004472.exe).

    3. Install the lastest patch for Precalculation Server (xPreCalServer09_1-10004472.exe).

    I had the same issue with the blank excel sheet, it was solved installing those patches (the patches must be at the same level to receive an excel filled with data).

    4. in BW, transaction RSPRECADMIN, create a new precalculation server (i have installed the precalculation server on a machine with win2k3 and it works fine)

    5. When you test the Precalc. Server, make sure you put in the "workbook" field the ID of the workbook. The sistem is sensitive to the name of the workbook (max. 25 Characters). You cand find the ID of the workbook in Bex Analyzer, choose the workbook and hit Properties button.

    6. Define a Background Job via SM36 with the program RS_PREC_PLAN. Before that you define a variant of the RS_PREC_PLAN, in which you setup what workbook to be calculated.

    7. Have Phun !!!

Actions