Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Adding Fields

Styleclass
ClasstopLink

top

To include a field in your table simply drag the field from the View Fields List, on the left of the page, to the Columns and/or Rows lists.

...

Field Types

Styleclass
ClasstopLink

top

Icon

Type

Description

Dimension

These are typically text or date fields and are used to describe the data.

Metric

These are the numeric values to be measured in the report. For example, sales sum, customer count, event count, average age.

Image AddedPropertyProperty details of the dimension fields. This appears when a connection to SAP BW's BEx layer is established.

Pre-Defined Filter

These are fields defined in the view to be used as filters in the report with pre-defined values attached, saving the user time defining the same filters over multiple reports.

Filter Group

These are like the pre-defined filters above, but are sets of filters, some of which may be set to user prompt rather than having set values.

Parameter

These are fields used to capture a value from the user which is then passed through to calculated fields or filters in the report.

...

Layout Options

Styleclass
ClasstopLink

top

There are three types of table layout available:

...

Data Validation

Styleclass
ClasstopLink

top

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:

...

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

Image Removed 

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. 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.

...

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 Removed 

 

 

Removing Fields

Styleclass
ClasstopLink

top

There are two ways to remove a field from your table:

...

Reordering Fields

Styleclass
ClasstopLink

top

There are two ways to reorder fields in your table:

...

horizontalrule
Styleclass
ClasstopLink

top