BEx Analyzer

The Business Explorer Analyzer is an Excel based tool of Business Explorer which can be used for Analysis
& reporting by designing the interfaces of our queries with the help of Workbooks. It’s a rich combination of SAP BI & Excel properties. We can create several views of data as per different requirements & user
preferences. It has a user-friendly interface which is same as Microsoft Excel with an additional BW menu & toolbar. BEx Analyzer provides several design items (controls) which enhances the reporting functionality.

The key features because of which one may opt for Workbooks:

The presentation of BI data in Excel format which allows the Users to utilize their Excel knowledge

Multiple reports can be combined into a single worksheet which provides a better comparison of scenarios

The look & feel of the report can be customized and calculations can be done locally in the worksheet itself.

Workbook can be precalculated & can be broadcasted to the users on a regular basis. The automation of this process can be done very conveniently.

The Password Protection feature of the workbook ensures the security of confidential data.

Steps to Create a Workbook:

Step 1: Open the BEx Analyzer.

Go to Start->Business Explorer->Analyzer

Step 2: Connect to the System

Select File -> New OR click New icon on the toolbar

Step 3: Insert a Query from BEx Query designer into a Workbook:

Select the Cell in the worksheet (Here it is D6) at which you want to start your Query embedding.

Now, Go to the Add-Ins tab and click over Insert Analysis Grid icon:

The Analysis Grid will get inserted at the desired cell selected in above step.

Now to insert the Query, click over the inserted Analysis Grid . A pop up screen

will appear which will navigate you to the Query which you created in BEx Query Designer

Click on Create Data Provider tab. Another Pop up screen will appear . Here Click on Assign

Query/Query View icon which will take you to the BEx screen where we can find & select our

already created Query.

Here if we simply want to insert our BEx Query in to the workbook without any formatting check

Apply Formatting, Allow Navigation & Display Sort icons options which will keep the convention

BEx Query designer formatting intact.

The data will automatically fit itself in into the sheet without checking the AutoFit option.

Click Ok .

Step 4: Inserting a query/view with Custom template

Instead of using the standard format, we can customize the template and create fixed formatted reports by

using excel properties.

We can design the template as per the requirement. We can adjust the look and feel of the Report output

through this and we can get an interesting layout for the Report besides the convention Query Designer

output.

Various Excel properties like Font color & size, Background color, Borders, formulas to calculate Result

rows, inserting Logos, merging sales can be used.

Few points to consider while designing a custom template.

1. You can hide the row in which query has been inserted; so that the header line of query output can

be hidden & a formatted header can be set.

2. While inserting the query , uncheck Apply Formatting, Allow Navigation, and Display Sort Icons as

we do not want the format properties of BEx

3. Before creating the format, one should be aware of the result area of the report.

Apart from the Excel settings, there are various other settings which are offered by Analyzer for the

workbook. We can set these as per our requirement by clicking on Workbook Settings icon in the Add-Ins

tab:

The above screen will appear which has the following options in GENERAL tab:

Refresh Workbook on Open: To avoid the manual refresh of the Workbook saved locally,this option needs to be checked. By this the Workbook will automatically connect to the server on opening and will fetch the latest data loaded to the info provider.

Use Compression when Saving Workbook: Checking this option helps to reduce the memory consumed

for saving the workbook. This Option is very useful when the volume of data is quite high and we have lot of

local calculations in the workbook.

Password-Protect Workbook: It is a very important feature of analyzer workbooks which ensures security

of data .Checking this option password protects all the sheets and changes cannot be done using analyzer

functions without providing the password.

To set the Password, check this option which in turn will enable the below two fields asking to enter & reenter the password :

DATA PROVIDERS tab will display all the info providers which are being used as a source in all the sheets of this workbook. New data provider creation/deletion is also possible through this tab.