Automating BEx Interface Using Worksoft Certify

BEx Analyzer :

The BEx Analyzer runs within Microsoft Excel and is available as part of the SAP GUI. Which will be included in BW Module. Security access is required to run the reports and planning queries.

SAP Business Explorer (BEx) provides you the set of tools to perform reporting, query analysis and to support strategic decisions. It is a complete product which provides different  reporting procedures and an analysis tool to run queries and reports with SAP NetWeaver BISystem.

SAP Business Explorer is a front-end tool to run different types of reports, analyze data and perform business planning on top of OLAP cubes which are stored in SAP Business Warehouse System.

Open BEx Analyzer :

The BEX Analyzer is an analysis based reporting and designing tool embedded with Microsoft Excel , Which can be viewed in Microsoft Excel Add-In Menu .

Open Query or Workbook:

For reports and planning workbooks, click on the Open Query icon (or Open Workbook) as shown in below.

Pre-Requisite For Accessing BEx Through Certify:

1. Open SAP GUI .
2. NavigatetoBW
3. Launch Bex Analyzer through TCodeRRMX
4. Import BEx

How to import BEx maps into certify :

1. Create Application in Certify (i.eBEX)
2. Create Version (1.0) in application BEX by selecting BExfrom interface selection
3. Import BEx maps into the version 0

From Certify, import the dynamic window, Main Window.map, from the following directory:

Worksoft> Certify >Interface Client >Worksoft>wsTest>BEx> Maps

4.Integrate created application(BEx) into the current project.

The SAP BEx interface has the following three Worksoft classes:

1. Window:ThisclassconsistsofactionsthatworkdirectlywiththeMicrosoftExcel workbook and
2. DataGrid: This class consists of actions that work directly with the data grid on the BEx sheet
3. Filter This class consists of actions that work directly with the filter grid on the BEx

Filter and DataGrid are looks as shown below:

Let’s consider 2 examples and see how to automate Bex Analyzer using certify.

Example 1:- In the Filter Area(shown above), need to input the values for the field Posting level.

Below are the certify steps will input filter value using Set Filter value action. Certify Screenshot :-

Output :-

Example 2 :- From the Data grid(Shown above), need to store the values.

Below are the certify steps that will store the data from a DataGrid using Find row in column and store cell actions.

Certify Screenshots :-

1. Find Row in column

      2. Storecell

Output:-

Commonly Used Actions :

Class	Action	Description
Window	Open Query	Open Query having technical name: <*Query Id> and wait for results: <*WaitForResult> and wait <*WaitTime> seconds before responding back.
Window	Display Table	Display Table
Window	Close Workbook	Close Workbook
DataGrid	Find Row By Column	Find Row By Column Where Column1: <*Search Column 1> = <*Search Value 1>, Column2: <*Search Column 2> = <*Search Value 2>, Column3: <*Search Column 3> = <*Search Value 3>, Column4: <*Search Column 4> = <*Search Value 4> and store in <*Row Number>, send Mouse Click <*Mouse Click>
DataGrid	Store Cell	Store Cell <*Cell Value> from Row <*Row Number> and Column
DataGrid	Verify Cell	Verify Cell <*Cell Value><*Criteria> from Row <*Row Number> and Column
Filter	Set Filter Value	Set Filter Value <*Filter Value> for Filter <*Filter Name>

Filter	Store Filter Value	Store Filter Value <*Filter Value>for <*Filter Name>
Filter	Verify Filter Value	Verify Filter value <*Filter Name><*Criteria> <*Filter Value>