Page History

...

See Table Layouts for more information.

Data Validation

Data validation checks are made by Yellowfin to ensure you are building your report the way in which the administrator intended. You will be prompted if you have used fields and filters incorrectly with the following messages:

Mandatory

The fields shown in this type of message must be included into the field or filter section of the report. For example:

Image Added

A variation of the mandatory field section validation is when a selected field in the table is being aggregated by sum or average. Constraints can be set when this occurs so that meaningful data is presented in the report. The validation message will look like this:

Image Added

To proceed with your report you can remove the sum or average aggregation on the selected field or drag the relevant fields indicated in the validation message into the report.

Excluded

The fields shown in this type of message must not be included into the field or filter section of the report when a selected field in the table is being aggregated by sum or average. Constraints can be set when this occurs so that meaningful data is presented in the report. The validation message will look like this:

Image Added

To proceed with your report you can remove the sum or average aggregation on the selected field or remove the relevant fields indicated in the validation message out of the report.

Suggested

When a suggested field or filter occurs, a messages box will appear with the suggestion. The user can chose to include this field or filter into the report or to ignore the suggestion.

Image Added

In list

When constraints are set up on a report, one of the options is to select a few fields from a table and set the constraint as one in list. This means that at least one of the selected fields must be included in the report. When this validation message is displayed it will show the list of all the fields where at least one must be included in the report. To fulfil this constraint simple make sure one of these fields are included in the report.

Image Added

Removing Fields

...