This section describes how to use the view builder to create views of your database that end users can access for reporting purposes. These views are built by first creating an entity relationship diagram which joins all required tables together.
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.
For example you may want to build a fairly complex view that provides significant flexibility to your end users (more fields and tables). In general reports that are written will not include all possible fields. In this way you can deliver less views to your end users therefore reducing the administration complexity.
A relationship diagram is a representation of a database view that shows the tables and joins between those tables. Using the Yellowfin View Builder you can create a relationship diagram for a sub set of your source database.
The relationship diagram contains tables and joins. The tables contain columns to which you apply a metadata so that business end users can use for creating reports.
The joins link the tables so that the correct data is returned for queries that are run on more than one table.
You build your relationship diagram on the canvas by selecting tables from the source database using table list. You create joins to link the tables. When you have built the relationship diagram for your view, you can test the view using integrity and impact analysis checks.
The list of database tables assists you to build your relationship diagram. Use the Table List to view and select tables in your database that you want to add to your view.
By expanding the node next to a table name you display the fields for the table. The list also provides an indication if the element selected is a table or a database view.
Note: the number of default tables shown is a configuration item – 50 is the default
You start building your view by selecting available tables from the source system and dragging them onto the Design Canvas.
In your view you can drag multiple versions of the same table. This may be needed if you which to access the same table but in different ways.
See Table Properties for more information.