/
Browse
/
Courses
/
Creating Queries in SAP BW/4HANA
/
Optimizing Query Performance
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 3 right to pass this unit.
1.
Which are some functions of the query monitor?
There are five correct answers.
Test and check for SAP BW/4HANA queries.
Regenerate SAP BW/4HANA queries.
Change SAP BW/4HANA query definitions.
Check and monitor performance.
Change performance-relevant SAP BW/4HANA query properties.
View technical information about SAP BW/4HANA queries.
Delete SAP BW/4HANA queries.
2.
For which object types can you the set the run-time property Operations in SAP HANA to force pushdown of BW Queries to SAP HANA?
There are three correct answers.
CompositeProviders
Characteristic InfoObjects
BW Queries
DataStore Objects (advanced)
3.
Which of the following are query read modes for SAP BW/4HANA queries?
There are two correct answers.
Query to read all data at once.
Query to read data on refresh.
Query to read only aggregated data.
Query to read data during navigation.
4.
Users require reports that display a list of customers and their sales volumes. Occasionally, the users need to drill down to the material level to identify what the customers bought. With which query layouts can you optimize the performance?
There are two correct answers.
Customer and material in the rows.
Customer and material in the free characteristics.
Customer in the rows and material in the free characteristics.
Material in the rows and customer in the free characteristics.
Customer and material in the rows with rows hierarchy expanded initially to customer.