/
Browse
/
Courses
/
Creating Queries in SAP BW/4HANA
/
Implementing Variables in Queries
Creating Simple Queries
Creating Simple Queries
32 min
Quiz
Configuring Key Figures in Queries
Configuring Properties of Key Figures
19 min
Creating Restricted Key Figures
15 min
Creating Calculated Key Figures
16 min
Creating Calculated Key Figures with Boolean Operators
6 min
Creating Calculated Key Figures with Exception Aggregation
15 min
Quiz
Implementing Structures in Queries
Creating Structures
19 min
Resolving Formula Collision and Working with Cells
9 min
Quiz
Configuring Characteristic Properties, Attributes, and Hierarchies
Configuring the Properties of Characteristics
12 min
Creating a Query and Running Display and Navigation Attributes
8 min
Adding Hierarchies to Reports
17 min
Quiz
Implementing Variables in Queries
Introducing Variables
6 min
Creating Characteristic Value and Text Variables
15 min
Implementing Variables delivered by SAP BW/4HANA Content Add-on
19 min
Transferring Values Between Queries Using Characteristic Value Variables
14 min
Creating Formula Variables
8 min
Creating Hierarchy Variables and Hierarchy Node Variables
7 min
Specifying Details of Variables
16 min
Quiz
Defining Exceptions and Conditions in Queries
Creating a Query and Including Exceptions
13 min
Creating a Query and Including Conditions
13 min
Quiz
Working with the Report-Report Interface
Working with the Report-Report Interface
8 min
Quiz
Optimizing Query Performance
Optimizing Query Performance
12 min
Describing the SAP BW/4HANA Analytic Manager
15 min
Quiz
Managing Queries and Reusable Query Components
Managing Query Objects
31 min
Quiz
Creating Simple Queries
Creating Simple Queries
32 min
Quiz
Configuring Key Figures in Queries
Configuring Properties of Key Figures
19 min
Creating Restricted Key Figures
15 min
Creating Calculated Key Figures
16 min
Creating Calculated Key Figures with Boolean Operators
6 min
Creating Calculated Key Figures with Exception Aggregation
15 min
Quiz
Implementing Structures in Queries
Creating Structures
19 min
Resolving Formula Collision and Working with Cells
9 min
Quiz
Configuring Characteristic Properties, Attributes, and Hierarchies
Configuring the Properties of Characteristics
12 min
Creating a Query and Running Display and Navigation Attributes
8 min
Adding Hierarchies to Reports
17 min
Quiz
Implementing Variables in Queries
Introducing Variables
6 min
Creating Characteristic Value and Text Variables
15 min
Implementing Variables delivered by SAP BW/4HANA Content Add-on
19 min
Transferring Values Between Queries Using Characteristic Value Variables
14 min
Creating Formula Variables
8 min
Creating Hierarchy Variables and Hierarchy Node Variables
7 min
Specifying Details of Variables
16 min
Quiz
Defining Exceptions and Conditions in Queries
Creating a Query and Including Exceptions
13 min
Creating a Query and Including Conditions
13 min
Quiz
Working with the Report-Report Interface
Working with the Report-Report Interface
8 min
Quiz
Optimizing Query Performance
Optimizing Query Performance
12 min
Describing the SAP BW/4HANA Analytic Manager
15 min
Quiz
Managing Queries and Reusable Query Components
Managing Query Objects
31 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 7 right to pass this unit.
1.
What happens if no value is chosen for the hierarchy variable in the variable prompt?
There are two correct answers.
The characteristic is removed from the drilldown.
An error occurs if the variable has been defined requiring a mandatory input.
The characteristic values are displayed as a flat list.
The system automatically chooses the first hierarchy according to the technical name.
The query result returns no values.
2.
Which of the following statements regarding variables are correct?
There are three correct answers.
SAP Exit is a variable processing type that is only available for variables delivered by SAP BW/4HANA Content Add-on.
The only processing type for variables delivered by SAP BW/4HANA Content Add-on isSAP Exit.
Characteristic value variables can be used in all queries where the characteristic is used.
A hierarchy variable can get only one single value.
Variables always must get values so that the query can be executed.
3.
What do you have to consider when working with variables?
There are two correct answers.
You cannot use hierarchy variables in combination with hierarchy node variables.
Text variables must be set for mandatory input.
In order to display the lower and upper limit of an interval in a description, you need to define two separate text variables.
A variable can be used multiple times in one query.
4.
A characteristic value variable for the characteristic 0CALQUARTER that provides the current quarter, will generate the same quarter of the previous year if you choose an offset of -12.
Choose the correct answer.
True
False
5.
Which statements apply to the usage of Characteristic Value Variables with Replacement Path from a Query?
There are three correct answers.
The variable accesses the values from an additional query, the prequery.
The prequery has to be executed as often as possible to provide recent data.
The prequery is automatically executed each time the result query is executed.
The characteristic value variable has to be added to the Filter: Fixed Values section of the result query.
6.
How can you use formula variables?
There are three correct answers.
In formulas as operands with manual entry.
In restrictions with time characteristics for dynamic offset values.
In formulas as operands that are retrieved by replacement path.
As threshold values in exceptions and conditions.
As key values for characteristic restrictions.
7.
Which are valid processing types for text variables?
There are three correct answers.
Manual Input
Replacement Path
Authorization
Customer Exit
8.
For which of the following can a variable be used as a placeholder?
There are three correct answers.
Characteristic values
Structures
Hierarchy nodes
Formula elements