Page History
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
The two major steps in creating a view include:
- Relationship Entity Diagram - selecting the tables you need from your database and defining how data in these tables are joined
- View Field Selection - defining which fields you wish to make available from these tables and providing metadata for them.
See Views Overview for more information.
Entity Relationship
Styleclass | ||
---|---|---|
| ||
See Model for more information.
Selecting Fields
Styleclass | ||
---|---|---|
| ||
See Table Properties for more information.
Field Categories & Meta Data
Styleclass | ||
---|---|---|
| ||
Initially, fields selected from the previous step will all be in the Unattached panel in folders that represent the tables that they originated from. These fields have not had meta data associated with them and cannot be used by your report writers. You must assign fields to folders in the Available Fields panel. The reason you do this is to organise your fields in a way that is logical for the report writer, giving you the chance to group them differently than the table structure in the database.
See Prepare for more information.
Field Format
Styleclass | ||
---|---|---|
| ||
See Field Settings for more information.
Calculated Fields
Styleclass | ||
---|---|---|
| ||
Calculated Metric
This type of calculated field allows you to build a calculation that will return a numeric value as the result. In this example we will aim to calculate profit by subtracting cost from invoice figures.
See Calculated Fields for more information.
Date Hierarchy Fields
Date Hierarchy calculated fields allow you to build levels of a hierarchy based on a single date field in your database. This can then be used to define Drill Down hierarchies, or for other purposes in reports.
Drill Down Hierarchy
Styleclass | ||
---|---|---|
| ||
See Drill Down Hierarchies for more information.
Further Information
Styleclass | ||
---|---|---|
| ||
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||