Create Objects Using the Data Object Builder

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:

1. Select the tables from the data object tree and drag them to the work area.
2. 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 .

3. Click to remove the join between columns, if necessary.
4. 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.

5. 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.

6. Click the Properties tab and complete the following fields:

   • Name

   • Module

   • Description

7. Click Save.
   The new data object will appear on the data object tree to the left of the work area.