To explore a basic introduction to creating views, visit the Creating a View page.
When building a view, you have several methods available to you, including;
From here you can proceed directly to the Report Builder.
See Drag & Drop View Builder for more information.
From here you can proceed directly to the Report Builder.
Note: When writing an SQL view it is very important that you do not include an order by – since results are sorted by the Java application not the database. The order by will cause your view to fail.
Note: When creating an OLAP cube as a view you will have limited options for updating field information. This is because most of the metadata is already contained in the cube itself.
The view builder for a composite view differs in that rather than displaying tables from a selected database it allows you to join existing Yellowfin views together and create virtual tables from any defined database.
We strongly recommend the use of Advanced Sub Queries over Composite Views as the functionality is more flexible and robust. |