MicroStrategy - Transformations - Online Training Video by MicroRooster

[@utkarshsahu]

Excellent Work.

[@sandhya_exploresfoodandlife]

Hello, why does the metric with the transformation for the previous year show the same value as the current year? what do i do to get the value of the prev year? Thank you

[@MicroRooster]

You should be able to us the year attribute - 1 in a transformation.

[@gh123bvgdf]

Hello, Excellent Video. What can we do rectify if double counting appears? Any shortcuts?

[@MicroRooster]

Transformations don't produce double counting unless you define them somehow using the wrong formula or table...

[@paperrotta]

what can i do with a metric with a transformation, that i wouldn t be able to do with a metric with a filter inside ?? I mean a metric with the filter year 2014 is the same than a metric with the transformation year before ? or a metric with a filter with a promp where i can choose months ?? thanks, congratulations on ur videos

[@MicroRooster]

Transformations allow you to dynamically filter relative to the report filter. For instance if you had a transformation "last year" and a report prompt/filter of 2015, the report will render 2014 data for the transformed metric. Furthermore you can transform on multiple levels, month and year for example. Finally with transformations you can custom the transformation based on a table, which allows for non traditional transformations such as fiscal calander transformations.

[@McGeeeeesees]

Excellent video once again. However you mention expression-based transformations but I don't think they were covered. Do you have another video on this, or am I misunderstanding?

[@MicroRooster]

Expression based is where you create a transformation by choosing a column from a given table; for instance you can pick Time_Dimension > Day_ID and then add "-1" to create yesterday's transformation. Your Expression will look like this "[Day_ID] - 1" ; then you can use this on any metric definition to produce a "Yesterday" version of the metric and place it next to a "Today" version of the metric.