- Measures are dynamic, it means the values are based on the context in which the measure is placed or the dimensions associated with it.
- Measure objects have sql aggregate functions and report projection functions.
An aggregate function operates on a group of rows rather than a single row. Some projection functions are Min, Max, Sum, and Database Delegated.
Database Delegated When a user drags or drops objects from the report or off from the report, the measure value will automatically adjust accordingly because of projection functions we set. Note: Averages and percentages cannot be projected for that we use database delegated function. If set the end-user will be asked to refresh the report. Averages, percentages and any other calculation that involves division will use database delegated function. Like sum percentages are not recursive. Ex: a sum of 2, 3 is same as 4, 1. But an average of 1, 2, 3 is not same as 1, 2.5 and 2.5.