Transformations
A transformation is a schema object that is created using other project attributes and can only be assigned to metrics. This is used for time series analysis; say, you want to calculate the growth percentage, namely how much your company revenue has grown this year compared to how much it grew last year. The transformation, once created, can be used for n number of reports that require time-based analysis.
Building a transformation
For table based transformation (YTD), we create a reference table with two columns, where the first column is the current date and the second column holds the date, required to calculate the running total based on the current date.
The reference table in our case looks like the following:
As we migrated ...
Get Mastering Business Intelligence with MicroStrategy now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
