You can create objects by dragging and dropping the tables you want to include, add joins if needed, and add details on the Properties tab. You can also fine-tune the data using the SQL Editor tab.
To create data objects using the Data Object Builder:
-
Select the tables from the data object tree and drag them to the work area.
-
A validation message displays to notify you if tables need to be joined.
There are two way to join tables:
-
Click the column from the first table, then drag and drop to the corresponding column on the second table. The columns are automatically be joined with the default
Join Type; or
-
Select the column in each table, select a different
Join Type, if desired, and click
.
-
Click
to remove the join between columns, if necessary.
-
Select the check box next to the columns from each table that you want to use for the new data object.
Clear the check box next to the columns that you do not want to use.
-
You can click the
SQL Editor tab at any time during the data object creation process, to view the SQL expression.
Click the
Preview button to see the data the report pulls.
-
Click the
Properties tab and complete the following fields:
-
Click
Save.
The new data object will appear on the data object tree to the left of the work area.