Start of Content Area

Background documentation Microsoft Excel Integration Locate the document in its SAP Library structure

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.

Tasks on Demand

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: Structure linkGlobal Settings

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: Structure linkWorkbook Settings

Tasks Performed Regularly

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

      Structure linkAdministration of the Precalculation Server

Troubleshooting

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 Structure linkGlobal Settings.

 

 

 

 

End of Content Area