When users must create a LastYear'sMonth transformation but there is no data for last year's month in the warehouse, the last year's data must be calculated by defining the appropriate expression.
In the Strategy Tutorial project, if there was no data available for last year's month, the following syntax can be used to generate the IDs for last year's month:
The transformation expression for the Month attribute can be defined as:
Note: Depending on the data for the IDs in the warehouse, appropriate expressions can be defined for other transformations also.
