Level of detail calculations (sometimes abbreviated as LoDcalcs or LoD expressions) allows you to perform aggregations at a specified level of detail, which may be different from the level of detail defined in the view, and then work with the resulting value at a row level. In this way, you can think of LoD calculations as a hybrid between aggregate calculations and row-level calculations.
Level of detail calculations follow this basic pattern of syntax:
{[TYPE] [Dimension 1],[Dimension 2] : AGG([Measure])}
The parts of the declaration above are as follows:
- TYPE: This is the type of LoD calculation (
FIXED
,INCLUDE
, orEXCLUDE
); these are described in detail in the following section. - Dimension 1: This is 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: This is the aggregate function you wish to perform...