Functions of the BEx Toolbar 

Use

When you start the Business Explorer Analyzer, the BEx toolbar appears in Microsoft Excel. It allows you to access all the important functions for navigating and analyzing the query data.

The BEx toolbar functions are also in the Microsoft Excel main menu under SAP Business Explorer.

Features

 

Open

This symbol takes you to the BEx Open dialog. You can open the following object types:

·        Workbooks

·        Queries

·        Saved query views

·        Exceptions

Depending on the type of object that you have selected, the BEx Open dialog appears differently with the specified functions.

See also:

Open

Open Dialog

Save

With the Save function on the BEx toolbar you can

·        Save the workbook as a new workbook

·        Save the workbook as an existing workbook

·        Change the title of the workbook

·        Save the query view as a jump target

·        Save the query view globally

If you save the workbook, the query is not detached. You can call the workbook at a later date, create a connection to the Business Information Warehouse Server, and refresh the queries contained in the workbook.

See also:

Save

Save Dialog

Refreshing Queries

Refreshing the query means to request the current valid data from the BW Server. The query is automatically refreshed when you insert it into the workbook and when you change the navigational status, that is, unless you have activated the function Stop Automatic Refresh (see also: Settings).

Therefore, you only usually need the Refresh Query function in the following cases:

·        To update the data after you have opened a workbook

·        When you fill the query with new variable values

A query can only be refreshed if a connection exists between the Business Explorer and the Business Information Warehouse Server.

See also:

Refreshing Queries

Back

Choose Back if you want to undo your last navigation step.

See also:

Navigation and Navigation Functions

Changing Queries

You use the function Change Query  on the BEx toolbar if you:

·        Want to change the arrangement of characteristics and key figures into rows, columns and free characteristics for the query and carry out several navigation steps one after the other (Change Query® Change Query (Local View)

·        Want to change the definition of the query (Change Query  ® Change Query (Global Definition)).

·        Change variable values

See also:

Change Query

 

Goto

With this function you can:

·        Display exceptions in the alert monitor, providing that some exceptions have been found for this query.

·        Jump to a saved query view

·        Reach jump targets using the report/report interface

·        Activate the function Repeat jump on double-click, to use double-click to jump to a saved view of query data

See also:

Jump

OLAP Functions for Active Cells

If you choose OLAP functions for active cell, you call the OLAP functions in the Business Explorer. They are available on the cells for the filter and results areas of a query. The context menu you call depends on whether you select a cell in the filter area of the query or a cell in the results area of the query.

You can also jump to documents for single master data and characteristic values or documents for the navigation status.

See also:

OLAP Functions for Active Cells

Formatting

Formatting for the query underlines the type of data contained in a cell, highlighting the structure of the delivered results. Query formatting consists of:

·        Fonts

·        Templates

·        Borders

·        Alignment

·        Defining symbols for:

¡        Expanding hierarchically

¡        Collapsing hierarchically

¡        Expanding in other dimensions

¡        Linking to documents

·        Hierarchy indentation

¡        Narrow

¡        Normal

¡        Wide

¡        Very wide

You can change the format of the query to configure the display however you like.

See also:

Formatting

Layout

Using the layout functions, you can change the appearance of the screen for the query in the workbook.

You use the layout functions to:

·        Attach a diagram or a map

·        Display text elements for the query

·        Display exceptions or conditions

·        Move the filter area or the results area

·        Mark queries on worksheet

See also:

Layout

Tools

You use the functions under Tools to:

·        Display the query in a default view in the Web browser

·        Call up the Query Designer

·        Insert, copy, remove queries

·        Remove all queries, delete the results and detach queries from the workbook

·        Distribute workbooks and call the BEx Broadcaster to do so

·        Activate SAP sheet protection

See also:

Tools

Settings

You use the functions under Settings to determine whether:

·        Queries are refreshed automatically

·        There is a connection to the BW server

·        Information about the BW server is displayed

·        A new workbook it is created from scratch, selected from a list or based on an existing template

·        OLAP functions are available using the right mouse button

·        Server warnings are suppressed

·        Log book entries are recorded

See also:

Settings