This scenario variant describes how business experts run complex analyses on BI data and use Microsoft Excel functions at the same time. The BEx Analyzer, which is a design and analysis tool embedded in Microsoft Excel, is available for this purpose. With the BEx Analyzer, BI data can be presented and analyzed interactively in workbooks.
The workbooks that are created 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. Information broadcasting functions are used for this purpose.
The most important administration tasks that are to be executed on demand are:
Tasks |
Further Information |
Setting standard workbooks |
In the BEx Analyzer, you can configure a standard workbook on the BI server. The standard workbook is the workbook in which queries are opened. You can adapt a workbook and the associated worksheets individually, as required. To do this, use the functions in Microsoft Excel or the BEx Analyzer design and set the standard workbook for any queries that are opened afterwards. More information:
|
Setting BEx themes |
BEx themes are common services in the Business Explorer Suite that provide format definitions for workbooks. In the BEx Analyzer, themes are based on the format definitions of Microsoft Excel and include formatting information, such as background color, font, and font size. More information:
|
You perform the following tasks regularly:
Tasks |
Further Information |
Administrating precalculation servers |
To precalculate workbooks, you manage the precalculation server in Customizing for the BI system. For more information, see ● SAP Reference IMG ® SAP NetWeaver ® Business Intelligence ® Settings for Reporting and Analysis ® Settings for Information Broadcasting ® Administrate Precalculation Server |
In the 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.
For more
information, see Global
Settings.