Level of detail syntax

Level of detail calculations follow this basic pattern of syntax:

{FIXED|INCLUDE|EXCLUDE [Dim 1],[Dim 2] : AGG([Row-Level])}

Definitions of the preceding declaration are as follows:

• FIXED, or INCLUDE, or EXCLUDE, is a keyword that indicates the type of LOD calculation. We'll consider the differences in detail in the following section.
• Dim 1, Dim 2 (and as many dimensions that are needed) are a comma-separated list of dimension fields that define the level of detail at which the calculation will be performed. You may use any number of dimensions to define the level of detail.
• AGG is the aggregate function you wish to perform (such as SUM, AVG, MIN, and MAX).
• Row-Level is the row-level field or row-level calculation that will be aggregated as specified by the aggregation you choose.