Big4Guy

A couple of weeks back, I had explained the concept of SAP BW BEx Analyzer. SAP Business Explorer BEx comes with a Excel Addin in the form of a toolbar. It integrates the SAP BW reporting functionality into Microsoft Excel. Queries can be evaluated in microsoft excel workbooks. Using the toolbar, one can manipulate query data in the way one likes. Once data is queried, same can be saved in presentation format. One thing to remember here is that data can also be saved in the SAP BW server from where it can be retrived later. The SAP BEx toolbar once installed automatically comes in Microsoft Excel as an additional toolbar / Addin. The toolbar looks something likes this.

For each of the icons / buttons in the toolbar, I have given a number explaining what each button is used for.

1. Open - This button loads the workbook into excel.
2. Save - This can be used like any other save button where changes to a new workbook are saved.
3. Refresh Query - This button refreshes the query data so as to ensure that user is working with the most current query data. Once a workbook is loaded, data is automatically refreshed. In case auto refresh is turned off, one can refresh data with this button.
4. Back - Takes the user back to last navigastional step.
5. Change Query - This is used to change the arrangement of characteristics and key figures into rows, columns, and free characteristics.
6. Goto - This button displays exceptions found for a query in the Alert Monitor and jumps to a saved-query view.
7. OLAP functions for active cells - This calls the OLAP menu in SAP BEx with the respective functions.
8. Format - This button can be used to change the structure and appearance of the delivered results to change font, patterns, borders, alignment, or hierarchy display options.
9. Layout - This button attaches chart of map and displays test elements for the query.
10. Tools - This publishes the queries to the Web, saves view and publishes, edits global definition, inserts, copies, and removes queries, removes, deletes results, detaches all queries in a workbook, activates the SAP sheet protection.
11. Settings - This button allows the user to automate query refresh, embeds new workbooks, sets a permanent workbook template, provides OLAP right-click function availability, suppresses warning, turns trace on or off.
12. Help - This displays the online help.

Related Posts

Internal & External Number Ranges in SAP R/3
SAP MRP Materials Requisition Planning
SAP Concepts - Bill of Material BOM
PGI Post Goods Issue in SAP