SAP BW Exceptions and Conditions in BEx Queries
SAP Business Warehouse Query Design and Analysis
Exceptions and Conditions in Queries
1. Creating Exceptions in BEx Query Design
2. Creating Conditions in BEx Query Design
1. Creating Exceptions in BEx Query Design
• Exception Definition in the Query Designer
• To Create an Exception
• General Exception Definition Options
• To Enter Exception Values
• Exception Definition Evaluation
• Exception Definition Display
• Exception Definition Cell Restriction
• Cell Restrictions Operators
• Examples of Totals as Operators
• Cell Restrictions: Everything except Totals
• Exceptions Changes and Deletions
• Exercise: Create an Exception in the BEx Query Designer
2. Creating Conditions in BEx Query Design
o Create Condition in BEx Query Designer
o Configure Conditions and Characteristics Assignments
o Use Multiple Conditions in a Report
o Condition Definition
o General Conditions Options
o Define Condition Parameters
o Threshold Value Conditions
o Ranked List Functions
o Characteristic Assignment
o Multiple Conditions in a Report
o Exercise: Create Conditions in BEx Query Designer
