Operators for Defining Filters

Special operators are used in metric definitions to determine which data to include or exclude from metric computations. Operators help establish filters by specifying the conditions that determine whether any given fact value will be included or excluded from computing the metric at hand.

Because facts are categorized by attributes, filter conditions are defined by referring to particular attribute values of interest (for example, …WHERE Year = 2007) or by referring to scenarios where two attributes have the same value (for example, WHERE Date_Ordered = Date_Shipped). By specifying these conditions, you are able to delineate a wide range of fact values and specify whether they should be included or excluded from metric computation.

Select from the following topics to get more information: