/
Browse
/
Courses
/
Exploring the Advanced Concepts of SAP BusinessObjects Web Intelligence
/
Creating a Document with Multiple Queries
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 3 right to pass this unit.
1.
Which storage locations can you use to access an Excel file as a data source in the web client?
There are three correct answers.
SAP BI Platform Repository.
Google Drive.
Microsoft OneDrive, including SharePoint Online.
Local computer hard drive.
2.
What happens if you choose not to refresh a specific query when refreshing a Web Intelligence document?
Choose the correct answer.
The query keeps the data from the previous refresh, stored in the microcube.
The query is deleted from the document.
The query automatically updates with the latest data.
The document cannot be refreshed at all.
3.
Which types of metadata can be exposed from a source Web Intelligence document to a target document?
There are three correct answers.
Dimensions, measures, and attributes
Hierarchies
Time and geo dimensions
Document formatting styles
4.
Which scenarios require the use of the Change Source wizard in a query?
There are two correct answers.
When moving a universe from a test environment to a production environment.
When updating a universe from UNV format to UNX format.
When adding new fields to an existing universe.
When deleting a query from a document.