Page History
Anchor | ||||
---|---|---|---|---|
|
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
...
for more information.
Create
Styleclass | ||
---|---|---|
| ||
1. Start the View creation process by using one of these methods:
- Left Side Nav - open the left side navigation panel, click on Create, select the View option
- Top Right Button - click on the create button, select the Viewoption.
...
- Admin Console - navigate to the Admin Console, open the Views section, click on the Add button.
...
Location | Preview |
---|---|
Left Side Navigation | |
Top Right Button | |
Toolbar | |
Admin Console |
2. From here you will need to either;
...
This section will walk through the initial steps of creating the view, including selecting the data source connection to base it on and the builder type to use.
Expand | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||
|
...
We're going to select Ski Team from the source type list.
3. You will now see the basic parameters required for your view. We are going to look at a more complex view, so select the Multiple Tables option.
4. Click on the Edit View option in order to access the main view builder.
...
|
...
|
...
|
...
|
...
|
...
Entity Relationship
Styleclass | ||
---|---|---|
| ||
Expand | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
...
|
...
|
...
|
...
|
...
|
...
title | Click to Expand Instructions |
---|
|
...
|
See Drag & Drop View Builder for more information.
Selecting Fields
Styleclass | ||
---|---|---|
| ||
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
See Table Properties for more information.
Field Categories & Meta Data
Styleclass | ||
---|---|---|
| ||
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
See View Fields for more information.
Field Format
Styleclass | ||
---|---|---|
| ||
Expand | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
See Field Format 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.
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
See View 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.
Expand | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||
|
Drill Down Hierarchy
Styleclass | ||
---|---|---|
| ||
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||
|
See Drill Down Hierarchies for more information.
View Summary & Saving
Styleclass | ||
---|---|---|
| ||
Expand | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||
|
See View Summary for more information.
Further Information
Styleclass | ||
---|---|---|
| ||
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||