MicroStrategy ONE

What is an Operator?

Operators are used to manipulate individual data items and data sets. These data items are called operands or arguments. Operators are represented by special characters or by keywords. For example, multiplication is represented by an asterisk (*) and division is represented by a slash (/). Filtering conditions are expressions built from attribute forms, metrics, constants, expressions, and operators. For example, consider the following filtering definition:

Store_ID = 1

The definition above contains an attribute (Store), an attribute form (Store_ID), a comparison operator (=), and a numeric constant (1).

The following types of operators are used when specifying filtering conditions:

  • logical
  • comparison
  • rank and percent
  • pattern