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 to use database tables (Transformation tables) to define how a current time Attribute should be mapped.
You can check how table-based Transformations are created by navigating to MicroStrategy Tutorial
project | Schema Objects
| Transformations
and opening any transformation. For example, the Previous
Transformation, shown as follows:
Checking table-based...