/
Browse
/
Courses
/
Exploring the Advanced Concepts of SAP BusinessObjects Web Intelligence
/
Using Functions in the Formula and Variable Editors
Creating a Document with Multiple Queries
Discovering the Concept of Multiple Queries
10 min
Building Queries Based on Microsoft Excel
15 min
Building Queries Based on Web Intelligence Document
15 min
Changing the Data Source of a Query
10 min
Quiz
Working in Data Mode
Viewing Data
10 min
Preparing Data
10 min
Creating and Managing Cubes
20 min
Editing Object Properties
10 min
Quiz
Using Advanced Query Panel Features
Using Data from Another Query
6 min
Implementing Subqueries
13 min
Implementing Combined Queries
15 min
Quiz
Working with Calculation Contexts
Outlining Calculation Contexts
10 min
Redefining Calculation Contexts
20 min
Implementing Extended Syntax Operators
25 min
Implementing Extended Syntax Keywords
20 min
Quiz
Using Functions in the Formula and Variable Editors
Creating Formulas with Character Functions
20 min
Concatenating Character Strings
10 min
Implementing Date Functions
10 min
Applying Miscellaneous Functions
15 min
Using the If Function to Create Groups and Calculations
15 min
Quiz
Reporting with Additional Techniques
Implementing Data Tracking
15 min
Implementing Shared Elements
15 min
Quiz
Adding Interactivity to a Document
Filtering Dynamically Using Element Links
5 min
Creating Custom Tooltips
10 min
Using Hyperlinks
20 min
Quiz
Creating a Document with Multiple Queries
Discovering the Concept of Multiple Queries
10 min
Building Queries Based on Microsoft Excel
15 min
Building Queries Based on Web Intelligence Document
15 min
Changing the Data Source of a Query
10 min
Quiz
Working in Data Mode
Viewing Data
10 min
Preparing Data
10 min
Creating and Managing Cubes
20 min
Editing Object Properties
10 min
Quiz
Using Advanced Query Panel Features
Using Data from Another Query
6 min
Implementing Subqueries
13 min
Implementing Combined Queries
15 min
Quiz
Working with Calculation Contexts
Outlining Calculation Contexts
10 min
Redefining Calculation Contexts
20 min
Implementing Extended Syntax Operators
25 min
Implementing Extended Syntax Keywords
20 min
Quiz
Using Functions in the Formula and Variable Editors
Creating Formulas with Character Functions
20 min
Concatenating Character Strings
10 min
Implementing Date Functions
10 min
Applying Miscellaneous Functions
15 min
Using the If Function to Create Groups and Calculations
15 min
Quiz
Reporting with Additional Techniques
Implementing Data Tracking
15 min
Implementing Shared Elements
15 min
Quiz
Adding Interactivity to a Document
Filtering Dynamically Using Element Links
5 min
Creating Custom Tooltips
10 min
Using Hyperlinks
20 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 4 right to pass this unit.
1.
Which function should you use in Web Intelligence to include all values from the query in a calculation, even if some values are not displayed in the current table?
Choose the correct answer.
NoFilter
RunningSum
Sum
Rank
2.
Which of the following statements about the If function syntax are true?
There are three correct answers.
When comparing a single value, use the = sign before the value.
When comparing multiple values, use the InList operator with parentheses.
All values in an InList must be in quotes and separated by semicolons.
The If function cannot be used to modify calculations in reports.
3.
What function should you use to format a date as a string when it is concatenated with other text?
Choose the correct answer.
FormatDate
LastExecutionDate
FormatNumber
DateString
4.
Which function would you use to extract the last two digits from a four-digit year value, such as 2025, in a report?
Choose the correct answer.
SubStr
Replace
Right
Pos
5.
What is the purpose of the Pos function in the process of extracting the date from the opening date string?
Choose the correct answer.
To identify the position of the space separating the date and time.
To convert the string to a date type.
To calculate the number of days between two dates.
To remove all non-numeric characters.