Analysemodus 

Use

In the BEx Analyzer analysis mode, you analyze and plan with selected InfoProvider data by navigating interactively within queries you created using the BEx Query Designer, and within the interface you designed in the BEx Analyzer design mode. When you switch to analysis mode, results of your query are displayed in the Excel worksheet according to how you configured your data using design items.

Results of the query are displayed in the analysis grid design item. Within this grid, by means of the navigation pane and other design items, you can navigate using the context menu, using drag and drop, or using icons for sorting or expanding and collapsing hierarchies. When you navigate, you execute OLAP functions such as filtering, drilling, and sorting characteristics and key figures in rows and columns of the analysis grid. In addition, if you have defined input-ready queries, you can enter data in the analysis grid in order to execute planning functions.

For advanced programming capabilities, you can embed your own customized VBA programs (Visual Basic for Applications) into your workbooks. You can also use the BEx Broadcaster to precalculate and distribute workbooks. 

You can save workbooks in your favorites or in your role on the server for someone else to then open and work with in analysis mode. You can also save the workbook locally on your computer.

 

Activities

●      Access analysis mode using the dedicated analysis toolbar or using the BEx Analyzer menu. See also: Analysis Functions

●      Navigate in analysis mode by using either the context menu or drag and drop. See also: Navigating in Analysis Mode

●      Use the BEx Broadcaster to precalculate and distribute workbooks. See Precalculating and Distributing Workbooks.