We have seen throughout this course how measures behave dynamically alongside dimensions, i.e. measures aggregate or break-down depending on the number of dimensions used.

A measure object has a ‘calculation context’ based on the dimensions used, for example:

‘revenue by year’, or ‘revenue by store and year’, or ‘revenue by store, product and year’, etc

Web Intelligence associates ‘default contexts’ based on the dimensions against which measures are being used. You can override the default calculation context by using ‘extended syntax’ in the definition of the variables and/or formulas.

Extended-Syntax

Extended syntax is used to modify the default context of a measure in order to override the default aggregation of the measure.

This session describes how to create reports using advanced calculation formulas by using ‘extended syntax’ on ‘calculation contexts’.

37 – Advanced Calculations using Extended Syntax in Web Intelligence