Manually Create and Adjust Metadata

Data objects can be tables, views, stored procedures, .Net assembly methods, web service methods, functions, or SQL statements.

NOTE. Each Data Object must contain at least a “Name,” “Alias,” and “Unique Key Field.”

 

NOTE. It is possible to write the SQL statement for use as an object by clicking the custom SQL button ()
NOTE. Each Data Object must contain a unique Alias.

 

Joins

The Joins menu allows for modification of joins on Data Objects.

 

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.