You can use BEx Broadcaster to precalculate and distribute workbooks. The system generates Microsoft Excel workbooks with historic data. You specify when precalculation will take place. Workbooks can be precalculated at a predefined time or whenever data in the underlying InfoProvider changes. You can broadcast the precalculated workbooks by e-mail or to the portal, where they can be accessed by employees.
The Tools → Broadcaster option is only visible when a workbook is open. If you only open a query in BEx Analyzer, this broadcasting option is not available.
You can also call BEx Broadcaster from other areas and select the required workbook for broadcasting:
More information:Calling BEx Broadcaster
The Broadcasting Wizard provides step-by-step instructions for creating the broadcast setting. If you want to use this choose Create New Setting with Wizard.
You can find out more about the setting options in the various tab pages under
The system generates a Microsoft Excel file containing the precalculated data. Recipients can continue navigating in this file after logging on to BEx Analyzer.
The system generates a URL. Recipients can open the workbook in BEx Analyzer by using the online link and can then continue navigating in it.
The workbook is precalculated with these variable values.
You can only do this if a system administrator has set up a precalculation server in Customizing.
If this special server is not available, the system terminates.
The new setting appears in the overview in the upper screen area in BEx Broadcaster.
A new browser window appears displaying the processing status of the broadcast setting. If you want to close the window, choose Cancel.
More information:Scheduling Broadcast Settings
You have precalculated a workbook and have distributed it according to the chosen setting.
If you have not precalculated the workbook as a ZIP file, the recipients will receive the formatted workbook when they open the file. They can continue navigating in this workbook.
The recipient of the file needs a local installation of the BW front end to be able to logon to the BW system and navigate within the data.
The broadcast setting is listed in the upper screen area in BEx Broadcaster. All broadcast settings that were created for this workbook are displayed here.
If you want to edit or delete the broadcast setting, choose Edit orDelete in the context menu for the setting in question.