Manually Create and Adjust Metadata
Data objects can be tables, views, stored procedures, .Net assembly methods, web service methods, functions, or SQL statements.
- In the Main Menu click the Data dropdown and select Objects.
- A new Data Object can be added by clicking the Add button ().
NOTE. Each Data Object must contain at least a “Name,” “Alias,” and “Unique Key Field.”
_IGobject.png)
- Click the dropdown in the Name row and a list of available Data Sources will appear. Click next to each Data Source to show its views, tables, and stored procedures.
- Select one of these as the Data Object.
NOTE. It is possible to write the SQL statement for use as an object by clicking the custom SQL button (
)
- In the Alias row give the Data Object a name that will appear for the end-user in the report editor.
NOTE. Each Data Object must contain a unique Alias.
- The Key Fields row allows for the designation of an attribute(s) of the Data Object to be the primary key(s).
- The Category, Parameters, and Tenants Columns rows are optional. Refer to the Data Object section of this article.
- Click OK(
) at the bottom of the page to save these changes.
Joins
The Joins menu allows for modification of joins on Data Objects.
- In the Main Menu click the Data dropdown and select Joins.
- Add a Join by clicking the Add button (
).
_IGjoins.png)
- Select the dropdown in the From Object – To Object row and select the desired Data Objects.
- Select the dropdown in the Join Columns row and select which fields to join the Data Objects on.
- Set the Join Type (inner, left outer, right outer, or full outer).
- In the Relation Type column specify if the relation is One-to-One or One-to-Many.
NOTE. Joins can be given a weight. In the case where multiple join paths exist between two Data Objects, the join path with highest weight will be used.