SAP BEx Analysis Functions SAP BEX

What is SAP BEx Analysis Functions?

In this section, we will debate in detail about the diverse Analysis Functions in BEx. We will also learn how to make local calculations, adding conditions to progress data analysis and Exception Reporting.

Business Explorer – Performing Local Calculations

Using local calculations, you can do calculations on the numbers built in the current report view. For instance, to do a sum of the top 10 products in the list.

There are a few functions that can be used to perform Local Calculations −

Calculate Result As

You can use this function to recalculate the result rows in the BEx Web Application as per certain criteria. You override the standard calculation using local calculations. It comprises only those numbers in the calculation appear in the current application view.

This function can be used in the resulting areas −

• BEx Query Designer
• BEx Web Applications
• BEx Analyzer

Calculate Single Values As

This function is used to recalculate single values in web applications as per certain selection criteria.

This function can be used in the resulting areas −

• BEx Query Designer
• BEx Web Applications
• BEx Analyzer

You can also add conditions to expand the data analysis and then the data is made only as per that condition. When a condition is applied, it just eliminates the unrequited rows from the returned data.

Note − This condition doesn’t alter the values showed or the key figures in the result rows.

You can also state multiple conditions in a query, which can be divided using a logical AND.

The function to define a condition is available in the resulting Business Explorer tools −

• BEx Query Designer
• BEx Web Analyzer
• BEx Analyzer

In Web Applications

The resulting type of conditions exist −

• Ranked List Condition
• Threshold Value Condition
• Mixed Condition

There are different operators that can be used for Threshold Value Condition −

• = Equal To
• Not Equal To
• Greater Than
• >= Greater Than or Equal To
• < Less Than
• <= Less Than or Equal To
• [] Between
• ][ Not Between

There are different operators that can be used for Ranked List Condition −

• Top N
• Top %
• Top Total
• Bottom N
• Bottom %
• Bottom Total

You can also highlight the objects in the Business Explorer that are significant as likened to other objects. This lets you to find any deviation from the predefined or predictable results. Using Exception, you can highlight the objects which are critical to a query.

An Exception can be defined for the resulting areas of Business Explorer −

• BEx Query Designer
• BEx Web Analyzer
• Web Applications

Defining Exceptions in a Query Designer

When you select a query in the Query Designer to add an exception, you need to navigate to View → Exceptions.

In the Exception section area, choose New Exception from the context menu as shown in the resulting screenshot.

Select the Exception and Right Click → Edit. This will open the Change Exception window.

The next step is to define the Exception in the change exception window. There are different alert levels that you can select.

You can select from the resulting Operator types −

• = Equal To
• Not Equal To
• Greater Than
• >= Greater Than or Equal To
• < Less Than
• <= Less Than or Equal To
• [] Between
• ][ Not Between

Display Tab

You can define if an exception moves the data cells or the characteristic cells. As per the distinct setting, highlighting for the exception is showen on the numbers for the certain key figure or the text for the most detailed characteristic value.