Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
To explore a basic introduction to creating views, visit the Creating a View page.
View Builders
When building a view, you have several methods available to you, including;
Single Table View
Styleclass | ||
---|---|---|
| ||
This option allow allows you to automatically create a view based on a single table in the selected database. Yellowfin will automatically group metrics together, made up of numeric and date fields, and dimensions of text fields.
Ensure that the Single Table option is selected, and then choose a database table from the list. Two or more tables with the same name, will be differentiated by their schema name.
From here you can proceed directly to the Report Builder.
Freehand SQL View
Styleclass | ||
---|---|---|
| ||
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.
OLAP Cube View
Styleclass | ||
---|---|---|
| ||
- To create an OLAP cube view select an OLAP cube source from the Create New View window.
- Choose the cube from a list of available cubes.
- You can then proceed straight to the report building process.
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.
Stored Procedure
Styleclass | ||
---|---|---|
| ||
- To connect to a stored procedure select the stored procedure options from the create view drop down list.
- Select the Database and then the stored procedure you wish to connect to.
- Click the Edit View button to continue to the stores procedure parameters page. Yellowfin will automatically detect parameters which exist in your stored procedure and display this list on the page.
- You must fill in a value for each parameter. The value is only used to return column at this stage of the view builder. (The non-return fields will become automatic filters on the reports created from this stored procedure).
- When you have completed the parameter section click accept to return the list of fields in the result set.
- Complete the metadata as you would for a standard view. Note that the non-return parameters exist as filter fields.
- Filters will be added into each report created from the stored procedure automatically. They will not be visible on the report data page but will be displayed on the report filter page.
Composite View
Styleclass | ||
---|---|---|
| ||
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.
Warning | ||
---|---|---|
| ||
We strongly recommend the use of Advanced Sub Queries over Composite Views as the functionality is more flexible and robust. |
Note | ||
---|---|---|
| ||
The Import & Export functionality is unavailable for composite view content. |