Transformations are objects that are used inside Metric definitions (we will cover Metrics in the following chapters) to map a time period to another offset time period. The following is a quick reference table for this MicroStrategy Object:
This object will allow users to perform comparisons between different times, such as this month versus last month, or this year versus last year.
Transformation could be defined using an offset calculation or formula. For example, YEAR -1 to define last year. However, due to the complexity and dynamism of some calendars such as 4-5-4 calendars, it is recommended ...
