Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
|
...
- To create a new view:
- click the add view link from within the source record, OR
click on the Create menu in the main navigation bar and select View
The view initiate page will prompt a select of the type of view you wish to create and the data source connection to use. The choices you have are:Builder
Description
Use the Yellowfin builder to create a view on your database.
Use an SQL statement to create your view
Use to create a view which connect to multiple separate data sources and views.
Select an existing OLAP cube – you will not be able to add additional attributes to a cube.
The ability to create a view from existing stored procedures on you database.
- click the add view link from within the source record, OR
- Select a category for the view. This is used to limit the field item categories to an appropriate set. For example only Sales Related field categories will be displayed for a sales view.
- To create a new category click the create category link. This will open a popup window in which you can add a new category.
Drag and Drop Builder
Styleclass | ||
---|---|---|
|
...
See Drag ドラッグ& Drop View Builderドロップビュービルダー for more information.
Freehand SQL View
Styleclass | ||
---|---|---|
|
...
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.
Composite View
Styleclass | ||
---|---|---|
|
...
...
Warning | ||
---|---|---|
| ||
We strongly recommend the use of Advanced Sub Queries over Composite Views as the functionality is more flexible and robust. |
OLAP Cube View
Styleclass | ||
---|---|---|
|
...
...
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 next arrow 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.
horizontalrule |
---|
Styleclass | ||
---|---|---|
|
...