Defining Table Restrictions

Objective

After completing this lesson, you will be able to define table restrictions in SAP SuccessFactors Canvas Reports.

Objects Tab and Duplicate Objects

You can duplicate whole objects (and their columns) by choosing the Edit Table icon and then the Duplicate icon:

Choose Edit Table, then choose Duplicate.

Objects Tab and Table Restrictions

You can restrict objects by choosing the Edit Table icon and then the Edit Restriction icon.

Object restrictions allow filtering on that specific table without affecting the overall query. This can be useful to only pull through specific data elements as required into the query result without affecting the overall result set.

Restrictions are defined on the object in the same manner as query filter, for example, showing only Base Salary compensation information without removing employees that do not have a base salary from the query result set.

Sample table restrictions are shown.

Objects Tab and Object Removal

You can remove whole objects (and their columns) from the query by selecting X:

To remove objects, choose X.

Summary