Skip to end of metadata
Go to start of metadata

Introduction 

Variables are parameters of a query that are defined in the Query Designer and are filled with values when you execute the query. There are five types of Bex Variables which serve as placeholders for

  • Characteristic Values
  • Hierarchy Nodes
  • Text
  • Formula Elements
  • Hierarchies

The processing type determines how a variable is filled with a value during query runtime. The following processing types are available

See Overview of Variable and Processing Types for more details. In the following Formula Variables and Text Variables are not discussed since they do not handle characteristic restrictions. Topically they belong to OLAP Core.

Topics

Documentation

SAP Online Documentation
SAP Consulting Notes at a glance
  • 2555624 - Bex Variables: Query settings defined for characteristics are not taken into account
  • 1852783 - Processing of Variables on Refresh
  • 1968275 - Excluding Selections in a BW Query

  • 1809255 - BexAnalyzer: Variables behaviour in I_STEP = 1, 2 & 3
  • 1737559 - Variable cannot be calculated before aggregation in BW 7.3 an upwards
  • 1730446 - SAP-EXIT Variable could not be replaced - BRAIN 641
  • 1581996 - Provision for excluding the variables in QueryDesigner
  • 1694535 - Handling non-existing values on the variable screen
  • 1360345 - Melt Variable Functionality in Old Runtime with 7.X system
  • 1728643 - Interesting Facts about Text variables
  • 1272242 - Verifying variables again in I_STEP = 2
  • 1589478 - 0FISCPER and offset of special periods
  • 1147450 - VAR SCREEN 'Check' does not validate multiple single & Range
  • 912473 - Brain 039 in customer exit variables for hierarchy nodes
  • 976680 - Usage of variables in authorization
  • 492504 - Dependent customer exit-type variables

SAP Support Troubleshooting Guideline

SSG BW-BEX-OT-OLAP-VAR