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.
About Workbooks
A Bex Analyzer workbook is nothing but an excel sheet which acts as a place holder for a Query result.
A workbook allows us to change the look & feel of a Report by which we can create formatted reports. We can easily insert a Query into the workbook and customize its appearance. We can apply Excel calculations & format properties.
Multiple queries can be inserted together in a single worksheet and can be used for comparative analysis and thereby creating a package of reports with coherent look & feel.
Apart from this Information Broadcasting is the most important feature of workbook which allows pre calculation of the workbook (time for which can be defined as per convenience & data availability) and automated broadcasting to the intended recipients.
A workbook allows us to change the look & feel of a Report by which we can create formatted reports. We can easily insert a Query into the workbook and customize its appearance. We can apply Excel calculations & format properties.
Multiple queries can be inserted together in a single worksheet and can be used for comparative analysis and thereby creating a package of reports with coherent look & feel.
Apart from this Information Broadcasting is the most important feature of workbook which allows pre calculation of the workbook (time for which can be defined as per convenience & data availability) and automated broadcasting to the intended recipients.
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
2. Select File -> New OR click New icon on the toolbar :
.
- 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 pre calculated & 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.
Creating Workbooks
Steps to Create a Workbook:
Step 1: Open the BEx Analyzer.
2. Select File -> New OR click New icon on the toolbar :
Step 2: Insert a Query from BEx Query designer into a Workbook:
A. Select the Cell in the worksheet (Here it is B2) at which you want to start your Query embedding.
Now, Go to the Add-Ins tab and click over Insert Analysis Grid icon:
B.The Analysis Grid will get inserted at the desired cell selected in above step.
C.Now to insert the Query, click over the inserted Analysis Grid (Here, in Cell B2). A pop up screen will appear which will navigate you to the Query which you created in BEx Query Designer :
D.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.
E. Select your Query & then click on Open Query which will bring the control back on the previous screen :
.
F.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 .
G.You will be again reverted to the screen of Step 2. Here click on the Exit Design Mode icon (marked in above snapshot) in the Add-Ins tab.
H.Now you will be able to see the Report output in the worksheet with the BEx formatting.
I. Click the below Icon to switch the workbook in Design or Analysis mode for formatting.
The data will automatically fit itself in into the sheet without checking the AutoFit option.
Click Ok .
G.You will be again reverted to the screen of Step 2. Here click on the Exit Design Mode icon (marked in above snapshot) in the Add-Ins tab.
H.Now you will be able to see the Report output in the worksheet with the BEx formatting.
I. Click the below Icon to switch the workbook in Design or Analysis mode for formatting.
This will bring the workbook back to Analysis Mode. The rows & columns width can be adjusted just as we do that in Excel
for Example see how the Data Validity Time Stamp below.
Samsung 8GB Galaxy Tab 2 Wi-Fi Tablet - GT-P3113TSYXAR (Google Affiliate Ad)
Work Book Settings:
A. Click on settings from the Tool Bar.
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.
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 & re-enter the password :
Some Constants on the Work Book..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 & re-enter the password :
You may want to display on the Report like Standard objects like Time of Execution or User Name , Parameters etc. This can be achieved by using TEXT ELEMENT Button from Tool Bar.
Position the cursor on the sheet and choose the option.
Insert the Text Element, right click – go to properties – Constant tab.
You can display the current user, Query technical name and description, Infoprovider Information.
Options could be...
for Example see how the Data Validity Time Stamp below.
similar way we can use other Options like Filter/Dropdown etc.
Finally Save the Work Book to the Server so that it can reusable.
Samsung 8GB Galaxy Tab 2 Wi-Fi Tablet - GT-P3113TSYXAR (Google Affiliate Ad)
