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
- Manual Entry/Default Value
- Replacement Path
- Customer Exit
- SAP Exit
- Authorizations
- HANA Exit
See Overview of Variable and Processing Types for more details. In the following Formula Variables are not discussed since they do not handle characteristic restrictions. Topically they belong to OLAP Core.
Topics
- Define Variables
- Variables and Reference Characteristics
- Customer Exit Variables
- Bucket Variables
- Exclude Variables: see 1968275 "Excluding Selections in a BW Query"
- Variables in section 'Characteristic Restrictions' versus 'Default Values'
- Refresh Variables
- Variable Replaced with a Query
- Current Member Variables
- Variable Replaced with Authorization
- Dynamic Hierarchy Selection during Query Execution
- Optional or Mandatory Variables
- Variable Handling: SIDs Generated for New Values
- Variable for Visibility of Structure Elements
- Text Variables
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