Microsoft Excel Integration enables business experts to perform complex analyses of BW data and to use Microsoft Excel functions at the same time. BEx Analyzer - a design and analysis tool embedded in Microsoft Excel - is available for this purpose. BEx Analyzer enables you to present and analyze BW data interactively in workbooks.
The workbooks can be saved as favorites or made available to other users using the role concept.
Workbooks can also be precalculated and sent by e-mail to make them available to other user groups. You use information broadcasting functions for this purpose.
The major administration tasks to be executed on demand are:
Tasks | Further Information |
---|---|
Setting standard workbooks |
In BEx Analyzer, you can configure a standard workbook on the BW server. The standard workbook is the workbook where queries are opened. You can customize a workbook and the associated worksheets. To do this, use the functions in Microsoft Excel or BEx Analyzer design and set the standard workbook for any queries that are opened afterwards. More information:Global Settings. |
Setting BEx themes |
BEx themes are common services in the Business Explorer Suite that provide format definitions for workbooks. In BEx Analyzer, themes are based on the format definitions in Microsoft Excel and include formatting information, such as background color, font and font size. More information:Workbook Settings. |
Administrating Adobe document services |
To enable users to create a print version of the data as a PDF file, you have to configure and manage Adobe document services. More information:Adobe Document Services Configuration Guide. |
The following tasks are performed periodically:
Tasks | Further Information |
---|---|
Administrating precalculation servers |
To precalculate workbooks, you administrate the precalculation server in transaction RSPRECALCADMIN in the BW system. More information:Administration of the Precalculation Servers. |
In BEx Analyzer, you can record traces to analyze problems in workbooks. The recorded traces help to resolve problems that you report to SAP as customer messages.
More information:Global Settings.