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, 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

Find Row in column

      2. Storecell




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>

Leave a Reply

Your email address will not be published. Required fields are marked *