/
Browse
/
Courses
/
SAP BusinessObjects Information Design Tool
/
Data Restrictions
Basic SAP BusinessObjects Universe Design
Describing Universes
6 min
Working with Local Projects
17 min
Quiz
Data Connections
Defining Connections
21 min
Quiz
Data Foundations
Creating Data Foundations
43 min
Using Joins
42 min
Creating and Using Derived Tables
24 min
Quiz
Business Layers
Accessing Data through the Business Layer
24 min
Integrating the Business Layer Components
1 hr 11 min
Creating Measure Objects
33 min
Testing Objects
12 min
Quiz
Universe Deployment
Deploying a Universe
19 min
Quiz
Loops in a Data Foundation
Creating Loops on the Data Foundation
9 min
Resolving Loops Using Aliases
27 min
Resolving Recursive Loops
17 min
Resolving Loops Using Contexts
41 min
Quiz
Data Restrictions
Defining Data Restrictions
4 min
Applying Mandatory Data Restrictions
26 min
Applying Optional Data Restrictions
19 min
Quiz
Lists of Values (LOV)
Defining a List of Values
6 min
Associating a List of Values to a Business Layer Object
15 min
Quiz
Parameters
Creating and Using Parameters
19 min
Quiz
Navigation Paths
Defining and Creating Navigation Paths
23 min
Quiz
SQL Traps
Defining SQL Traps
2 min
Identifying a Chasm Trap
2 min
Resolving a Chasm Trap
21 min
Identifying a Fan Trap
2 min
Resolving a Fan Trap
21 min
Quiz
Object @ Functions
Using @ Functions in SQL
6 min
Using the @Aggregate_Aware Function
26 min
Using the @Select Function
12 min
Using the @Where Function
12 min
Using the @Execute Function
17 min
Using the @Variable Function
10 min
Quiz
Universe Management with Data Foundation and Business Layer Views
Managing the Data Foundation Using Views
2 min
Managing the Business Layer Using Views
22 min
Quiz
Universe Security
Securing a Deployed Universe with Security Profiles
4 min
Creating and Assigning Universe Security Profiles
29 min
Identifying the Priority of Security Settings
2 min
Updating a Deployed Universe
4 min
Quiz
Linked Universes
Defining and Creating a Linked Universe
6 min
Managing Core Universes
22 min
Including a Core Universe
2 min
Quiz
Basic SAP BusinessObjects Universe Design
Describing Universes
6 min
Working with Local Projects
17 min
Quiz
Data Connections
Defining Connections
21 min
Quiz
Data Foundations
Creating Data Foundations
43 min
Using Joins
42 min
Creating and Using Derived Tables
24 min
Quiz
Business Layers
Accessing Data through the Business Layer
24 min
Integrating the Business Layer Components
1 hr 11 min
Creating Measure Objects
33 min
Testing Objects
12 min
Quiz
Universe Deployment
Deploying a Universe
19 min
Quiz
Loops in a Data Foundation
Creating Loops on the Data Foundation
9 min
Resolving Loops Using Aliases
27 min
Resolving Recursive Loops
17 min
Resolving Loops Using Contexts
41 min
Quiz
Data Restrictions
Defining Data Restrictions
4 min
Applying Mandatory Data Restrictions
26 min
Applying Optional Data Restrictions
19 min
Quiz
Lists of Values (LOV)
Defining a List of Values
6 min
Associating a List of Values to a Business Layer Object
15 min
Quiz
Parameters
Creating and Using Parameters
19 min
Quiz
Navigation Paths
Defining and Creating Navigation Paths
23 min
Quiz
SQL Traps
Defining SQL Traps
2 min
Identifying a Chasm Trap
2 min
Resolving a Chasm Trap
21 min
Identifying a Fan Trap
2 min
Resolving a Fan Trap
21 min
Quiz
Object @ Functions
Using @ Functions in SQL
6 min
Using the @Aggregate_Aware Function
26 min
Using the @Select Function
12 min
Using the @Where Function
12 min
Using the @Execute Function
17 min
Using the @Variable Function
10 min
Quiz
Universe Management with Data Foundation and Business Layer Views
Managing the Data Foundation Using Views
2 min
Managing the Business Layer Using Views
22 min
Quiz
Universe Security
Securing a Deployed Universe with Security Profiles
4 min
Creating and Assigning Universe Security Profiles
29 min
Identifying the Priority of Security Settings
2 min
Updating a Deployed Universe
4 min
Quiz
Linked Universes
Defining and Creating a Linked Universe
6 min
Managing Core Universes
22 min
Including a Core Universe
2 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 filter lets you restrict the values returned whenever the table is used in a query?
Choose the correct answer.
Table filter
Column filter
Row filter
Function filter
2.
What is a predefined Where clause that can be inserted into the Select statement inferred by objects in the query pane?
Choose the correct answer.
Filter object
Inferred restriction
Column filter
3.
Which restriction is optional and applicable by end users?
Choose the correct answer.
Condition Objects
Object
Table
Conditional SELECT