Using a Projection Node
A Projection node is typically used in the following scenarios:
To filter measures based on attributes values.
To extract only some columns from a data source.
To define calculated columns, in particular when the calculation must occur BEFORE an aggregation.
Indeed, calculated columns in the Aggregation nodes of calculation views are always executed AFTER the aggregation.
