Skip to main content
Report Builder
Search
Search ONESOURCE Global Trade Support Help and Support.

This article applies to:

  • Product: ONESOURCE Global Trade
  • Sub-Product: Cross-platform tools

Glossary of Terms and Definitions

The following terms and definitions are used throughout this Help. Each term is explained in further detail in its corresponding section.
Term
Meaning
Field
Field values are the basic building blocks of any query.
Function
Functions perform basic math, grouping, or display only part of a value.
Conditional Statement
Conditional (CASE) statements use a series of IF…THEN statements to return a different value in a column, depending on one or more other related column values.
Restriction
Restrictions are the conditions that determine which data will be included in the report results.
Restriction Group
  • Restriction groups chain a group of restrictions together to build more complex conditions. Groups can also have other groups as child groups. Each group will connect its child restrictions via the
    AND
     operator or the
    OR
     operator.
  • AND
    : In order to be included, the line must satisfy all conditions laid out in the child restriction(s). Top-level restrictions are always chained with the
    AND
     operator.
  • OR
    : In order to be included, the line must satisfy one or more of the conditions laid out in the child restriction(s).
Order Element
Ordering is a sorting functionality that determines the order in which report data elements are displayed.
Pivot
A pivot is a method that takes unique values from a column and turns them into multiple columns, while aggregating other column values.
For example, instead of returning a three-column table containing Month, Country, and Value, a pivot could return a table containing a Month column, a new column for each Country, and the Value broken out across those Country columns.

Related Content