Configuring Tables in the Query

Objective

After completing this lesson, you will be able to configure tables in the query in SAP SuccessFactors Canvas Reports.

Objects Tab and Joins

The Objects tab will display how objects are related and how they link together.

The Objects tab, showing how objects are related.

Join Types

Inner Joins

Inner Joins show only records that exist in both objects. In this example, employee CCC is not shown in the query results because they do not exist in the Spot Bonus object.

Sample Inner Join result, as described in the preceding text.

Left Joins

Left Joins show all records from the object on the left and only records that match from the object on the right. In the example shown in the figure, Left Joins - Example, employee CCC is shown in the query results because they exist in the Global Job Information object, however with empty results from the Spot Bonus columns because they do not exist in that object.

Sample Left Join, as described in the preceding text.

Objects Tab and Column Selection

Choose Edit Table, and select the relevant checkboxes.

Choose the Edit Table button on the object to see all columns in the table. You can quickly include columns by checking the box beside the column. Choose Apply when finished to apply the changes to the query results.

Objects Tab and Column Relabeling

To relabel a column, select A and enter a new name.

The Edit Table button also allows access to setting a different column label. Select the A icon to give the column a new label, and then choose OK to save the label and Apply to set the changes in the query:

Columns Tab Overview

In the column tab, you can: Relabel the selected column. Remove the selected column. Open the sort function. Open the query filter function.

You can manage columns labels, sorting, and filtering from the Columns tab.

Summary

Next lesson