Skip to Content
author's profile photo Former Member
Former Member

Precalculation of Workbooks

Hi All,

Can anybody please give me step by step procedure on how to pre-execute the workbooks.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 03, 2008 at 11:33 AM

    Hi Pramod,


    1. In the analysis toolbar in the BEx Analyzer, choose Tools -

    > Broadcaster.

    The Tools -

    > Broadcaster option is only visible when a workbook is open. If you only open a query in the BEx Analyzer, this broadcasting option is not available.

    You can also call the BEx Broadcaster from other areas (see Calling the BEx Broadcaster) and then select the appropriate workbook for broadcasting:

    a. Under Settings for Object Type, choose Workbook.

    b. Choose Open.

    c. Select the required workbook from your history, favorites, or roles.

    d. Choose Transfer.

    2. Choose Create New Setting.

    If you want to work with the broadcasting wizard, which provides step-by-step instructions for creating the broadcast setting, choose Create New Setting with Wizard.

    3. Enter a description for the broadcast setting.

    4. Choose whether you want to broadcast the precalculated workbook by e-mail or to the portal. For more information about the relevant setting options on the corresponding tab pages, see Broadcast by E-Mail and Broadcast to the Portal.

    5. Select the required output format:

    ○ MS Excel Workbook

    The system generates a Microsoft Excel file containing the precalculated data. Recipients can further navigate in this file when they log on to the BEx Analyzer.

    ○ Online Link to Current Data

    The system generates a URL. Recipients can open the workbook in the BEx Analyzer by using the online link and can then further navigate in it.

    6. If you want to distribute the workbook as a ZIP file, select ZIP File.

    7. Choose the Workbook Precalculation tab page.

    If the workbook contains variables, you can also specify variable assignment.

    Determine Here: You can create the values for input ready variables in the workbook. The workbook is precalculated with these variable values.

    Determine from Variants: You can enter the required variant in the Variant field. The workbook is precalculated with the data for this variant.

    You cannot define variants for workbooks from SAP NetWeaver 7.0.

    Specify which precalculation server is to be used. For this, you have to set up a precalculation server. For more information, see Creating Precalculation Servers.

    ○ If you want the system to use the first available precalculation server from the precalculation servers set in Customizing, select Select Automatically.

    ○ If you want the system to use a specific precalculation server, choose Special Server and specify the server.

    If this special server is not available, the system terminates.

    8. If necessary, check your settings by choosing Check and then choose Save.

    9. Enter a technical name for the broadcast setting and choose Transfer. The new setting appears in the overview in the upper area of the BEx Broadcaster.

    10. If you want to distribute the broadcast setting for the workbook immediately, choose Execute. A new browser window appears that displays the processing status of the broadcast setting. If you want to close the window, choose Cancel.

    If you want to distribute the broadcast setting for the workbook at a specific time or when changes are made to the data, choose Schedule. For more information about scheduling broadcast settings, see Scheduling Broadcast Settings.

    go through link for info[]

    hope it helps U..



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      Is this explanation for workbooks in BW 3.5 ?

      Actually we have BI 7 server, in which the queries and workbooks are modelled in 3.x way. Can we precalculate workbooks in this scenario ?

      Please help me here



  • author's profile photo Former Member
    Former Member
    Posted on Apr 03, 2008 at 10:58 AM

    Hello Pramod,

    See thes links for [Precalculating and Distributing Workbooks|]

    [Precalculation of SAP BW Web Templates for Offline Use|]

    Even though the below doc is old you can have a look for some basic idea

    [Reporting Agent including Precalculating Web Templates|]

    Thanks [Chandran|]

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.