Page History

...

By using the Yellowfin view builder you can optimise the SQL that will be generated by the query. For example if you create a view where multiple tables are joined - – Yellowfin will only select data from the tables necessary to return data required for the report. This means that you can create relatively complex views without compromising on performance.

...

1. The process wizard assists you to move between the various steps in building your view.
2. The search and expand option allows you to search for tables in your data base
3. The virtual table allows you to create your own tables using freehand SQL.
4. The data base tables allow you to view all the available tables in your data source.
5. Drag the table to resize the table list and expand the size of your canvas.
6. The canvas - – it is on this section that you drop your tables and create joins between them.
7. Create Joins that link your tables together
8. View options - – manage the view details and table properties.

...

Note: the number of default tables shown is a configuration item - – 50 is the default

Drag Table onto Canvas

...