{"id":3720,"date":"2021-05-28T06:00:54","date_gmt":"2021-05-28T05:00:54","guid":{"rendered":"https:\/\/bestdatasolutions.es\/blog\/microstrategy-transformations-2\/"},"modified":"2021-07-07T10:13:15","modified_gmt":"2021-07-07T09:13:15","slug":"microstrategy-transformations","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-transformations\/","title":{"rendered":"MicroStrategy Transformations"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3720\" class=\"elementor elementor-3720 elementor-2195\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-187471cb elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"187471cb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8a0c01d\" data-id=\"8a0c01d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1fbff00b elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"1fbff00b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1920\" height=\"500\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Transformations.jpg\" class=\"attachment-full size-full wp-image-2250\" alt=\"MicroStrategy Transformations\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Transformations.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Transformations-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Transformations-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Transformations-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Transformations-1536x400.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d1c2c13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d1c2c13\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5aae2e0d\" data-id=\"5aae2e0d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a3ffa42 elementor-author-box--layout-image-left elementor-author-box--align-left elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--name-yes elementor-author-box--biography-yes elementor-widget elementor-widget-author-box\" data-id=\"1a3ffa42\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/es.linkedin.com\/in\/joacoatt\" target=\"_blank\" class=\"elementor-author-box__avatar\" rel=\"noopener\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/joaquin-attanasio-1.jpg\" alt=\"Picture of Joaquin Attanasio\" loading=\"lazy\" title=\"\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/es.linkedin.com\/in\/joacoatt\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tJoaquin Attanasio\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\tBusiness Intelligence Consultant | Microstrategy Expert | Data Specialist\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41a959e0 elementor-widget elementor-widget-heading\" data-id=\"41a959e0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-large\">Other Articles:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6c75b22c\" data-id=\"6c75b22c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5795bde9 elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"5795bde9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">MicroStrategy Transformations<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-561b31d1 elementor-widget elementor-widget-post-info\" data-id=\"561b31d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-869d2fb elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/bestdatasolutions.es\/en\/2021\/05\/28\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-calendar\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M12 192h424c6.6 0 12 5.4 12 12v260c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V204c0-6.6 5.4-12 12-12zm436-44v-36c0-26.5-21.5-48-48-48h-48V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H160V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H48C21.5 64 0 85.5 0 112v36c0 6.6 5.4 12 12 12h424c6.6 0 12-5.4 12-12z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>28\/05\/2021<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56263e9 elementor-widget elementor-widget-text-editor\" data-id=\"56263e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Welcome back! As every week, a new article in our little space <i>#BestInMicro<\/i>, a little corner where I share stories, experiences, learnings, secrets and techniques of the day to day life of a MicroStrategy consultant. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0bf3df elementor-widget elementor-widget-image\" data-id=\"f0bf3df\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"847\" height=\"472\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations.jpg\" class=\"attachment-full size-full wp-image-2201\" alt=\"Transformations\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations.jpg 847w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations-300x167.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations-768x428.jpg 768w\" sizes=\"(max-width: 847px) 100vw, 847px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b1048a4 elementor-widget elementor-widget-text-editor\" data-id=\"b1048a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This week I am taking you on a journey through time and space. Sounds like a Bradbury story or a Stephen Hawking theory, doesn&#8217;t it? So today we will take our metrics, put them in the <i>DeLorean<\/i> and make them travel back in time and into other dimensions to see what value they correspond to wherever we go. So fasten your seatbelts, because today we will be looking at: <i>Transformations<\/i>.&nbsp;<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a78e20 elementor-widget elementor-widget-heading\" data-id=\"7a78e20\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Transformations<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4028de2 elementor-widget elementor-widget-text-editor\" data-id=\"4028de2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Let me make it a little clearer&#8230; Let&#8217;s start with the transformations. Transformations are a schematic object in MicroStrategy, which allow to generate a direct link or relationship between different dimensions. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e716c10 elementor-widget elementor-widget-image\" data-id=\"e716c10\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"52\" height=\"58\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations-imagen.jpg\" class=\"attachment-full size-full wp-image-2205\" alt=\"Transformations Image\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5564d4 elementor-widget elementor-widget-text-editor\" data-id=\"d5564d4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The most commonly used example, and the easiest to understand, is if we look at it in the dimension of time. The transformation generates a relationship between, for example, the previous year, or the previous month, or a set of days corresponding to a week, etc. <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">For example, if today is 4 January 2021, the transformation to the previous year would be 4 January <\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem;\"><b>2020<\/b><\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">; the day before would be <\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem;\"><b>3<\/b><\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"> January 2021, or the cumulative year (also known as <i>Year To Date<\/i>, or YTD), would be 1, 2, 3 and 4 January 2021. <\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"> <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e717ddf elementor-widget elementor-widget-heading\" data-id=\"e717ddf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Transformed Metrics<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e24cab9 elementor-widget elementor-widget-text-editor\" data-id=\"e24cab9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Great! Now that we understand what we mean when we talk about transformations, let&#8217;s take it to where we want to go today. When you go to the metrics editor, you will have noticed that there are different options, such as the filter we apply to them, the dimensionality and there is one called transformation.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4000237 elementor-widget elementor-widget-image\" data-id=\"4000237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"451\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/metricas-transformadas.jpg\" class=\"attachment-full size-full wp-image-2209\" alt=\"Transformed Metrics\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/metricas-transformadas.jpg 796w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/metricas-transformadas-300x170.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/metricas-transformadas-768x435.jpg 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-57d8297 elementor-widget elementor-widget-text-editor\" data-id=\"57d8297\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>When we take a transformation and apply it to a metric, it is basically bringing that metric to the <u>dimension to which we are transforming it<\/u>. That is to say, if we apply the transformation of the previous year, it will return the value corresponding to the previous year for the row we are in. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c85fcad elementor-widget elementor-widget-video\" data-id=\"c85fcad\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=EAllWl5HG3Y&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-39b13b3 elementor-widget elementor-widget-heading\" data-id=\"39b13b3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Types of Transformations<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9d6317 elementor-widget elementor-widget-text-editor\" data-id=\"a9d6317\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Let move on. Once we understand what they are for and how they are used, the next step is to understand that there are different types, basically based on how we create them (but this does not mean that they cannot both be used in the same transformation). <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-66b1b2f elementor-widget elementor-widget-heading\" data-id=\"66b1b2f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Table-based<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99e7327 elementor-widget elementor-widget-text-editor\" data-id=\"99e7327\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This method consists of having a table in our warehouse, where a relationship is defined between an &#8220;origin&#8221; date and the date it refers to. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ba0869 elementor-widget elementor-widget-image\" data-id=\"4ba0869\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"301\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformadas-basadas-en-una-tabla.jpg\" class=\"attachment-full size-full wp-image-2213\" alt=\"Table-Based Transformations\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformadas-basadas-en-una-tabla.jpg 559w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformadas-basadas-en-una-tabla-300x162.jpg 300w\" sizes=\"(max-width: 559px) 100vw, 559px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a85af00 elementor-widget elementor-widget-text-editor\" data-id=\"a85af00\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In this way, we create a <i>&#8220;previous day&#8221;<\/i> transformation for the attribute <i>&#8220;Date&#8221;<\/i> where we assign the column <i>&#8220;previous date&#8221;<\/i> (or, well, whatever relation is of interest). <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">It works in a similar way for cumulative values: <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79b0215 elementor-widget elementor-widget-image\" data-id=\"79b0215\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"301\" height=\"295\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformadas-imagen-tabla.jpg\" class=\"attachment-full size-full wp-image-2218\" alt=\"Transformations Image Table\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06619c8 elementor-widget elementor-widget-text-editor\" data-id=\"06619c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Here you will notice that for each day (column <i>&#8220;date&#8221;<\/i>) you have all the corresponding values accumulated, either for the month or for the year in this example (being January \ud83d\ude0a). In this case it is important to define that the relationship in the transformation will be <i>many-to-many<\/i> (for the same value, several occurrences in the left column are related to several occurrences in the right column). For more information, <a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.10\/AnalyticsDesktop\/WebHelp\/Lang_3082\/Content\/Defining_relationships_between_attributes.htm\" target=\"_blank\" rel=\"noopener\">here<\/a> you can read more about it.) I&#8217;ll soon make a video showing examples of each case, so stay tuned!<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e3847f4 elementor-widget elementor-widget-image\" data-id=\"e3847f4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"453\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations-editor.jpg\" class=\"attachment-full size-full wp-image-2222\" alt=\"Transformations Editor\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations-editor.jpg 570w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformations-editor-300x238.jpg 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b4a690e elementor-widget elementor-widget-heading\" data-id=\"b4a690e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Expression-based<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21b509b elementor-widget elementor-widget-text-editor\" data-id=\"21b509b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In addition to the table, there may be scenarios where some kind of formula or calculation is required to obtain the target date, either because there is no possibility to generate the table, because it is a relatively more complex calculation, or because it is easier to generate the formula than to create the table. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-106b15a elementor-widget elementor-widget-image\" data-id=\"106b15a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"457\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformadas-basadas-en-una-expresion.jpg\" class=\"attachment-full size-full wp-image-2226\" alt=\"Expression-Based Transformations\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformadas-basadas-en-una-expresion.jpg 655w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transformadas-basadas-en-una-expresion-300x209.jpg 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a7ed7b elementor-widget elementor-widget-text-editor\" data-id=\"4a7ed7b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The use of this type of transformation allows formulas to be created using columns from the warehouse tables, constants, arithmetic operators and mathematical functions. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42a574e elementor-widget elementor-widget-heading\" data-id=\"42a574e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Conclusions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f69964e elementor-widget elementor-widget-text-editor\" data-id=\"f69964e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The use of transformations is a very common practice when analysing evolutions and comparisons, including SCD dimension analysis (<a href=\"https:\/\/www.businessintelligence.info\/definiciones\/dimensiones-lentamente-cambiantes-scd.html\" target=\"_blank\" rel=\"noopener\">Slow changing dimensi\u00f3n<\/a>), since, as I said at the beginning of the article, transformations are not exclusive to the time dimension, although they are the most common.&nbsp;&nbsp;<\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">As a big difference at the macro level between both methods of transformations, we can consider that those based on an expression can generate some kind of load on the server (as it has to do one more layer of calculation, while when using a table, everything comes directly from the warehouse).&nbsp;<\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">So much for this week, any doubts, questions, comments or whatever you want, without fear or shame! See you next week!&nbsp;<\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed803bf elementor-widget elementor-widget-heading\" data-id=\"ed803bf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">References<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e537c5c elementor-widget elementor-widget-text-editor\" data-id=\"e537c5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/www.youtube.com\/watch?v=Csy68aIh9vI\" target=\"_blank\" rel=\"noopener\">MicroStrategy &#8211; Transformations &#8211; Online Training Video by MicroRooster<\/a><\/p>\n<p><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10\/manuals\/en\/ProjectDesign.pdf\" target=\"_blank\" style=\"background-color: rgb(255, 255, 255); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" rel=\"noopener\">MicroStrategy Project Desing Guide<\/a><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">&nbsp;<\/span><\/p>\n<p><a href=\"http:\/\/microstrategyanalytics.blogspot.com\/p\/transformation-metric-with-no.html\" target=\"_blank\" rel=\"noopener\">MSTR Transformation Metric with no aggreagation<\/a><\/p>\n<p><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.3\/manuals\/en\/AdvancedReporting.pdf\" target=\"_blank\" style=\"background-color: rgb(255, 255, 255); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" rel=\"noopener\">MicroStrategy Advanced Reporting Guide<\/a><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">&nbsp;<\/span><\/p>\n<p><font color=\"#0081c5\">C\u00f3mo definir relaciones entre atributos<\/font><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.10\/AnalyticsDesktop\/WebHelp\/Lang_3082\/Content\/Defining_relationships_between_attributes.htm\" target=\"_blank\" rel=\"noopener\">&nbsp;<\/a><\/p>\n<p><a href=\"https:\/\/www.businessintelligence.info\/definiciones\/dimensiones-lentamente-cambiantes-scd.html\" target=\"_blank\" rel=\"noopener\">Dimensiones lentamente cambiantes (SCD)&nbsp;<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae60bf0 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"ae60bf0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/bestdatasolutions.es\/en\/blog\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">&lt;&lt; BACK TO BLOG<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>This week I am taking you on a journey through time and space. Sounds like a Bradbury story or a Stephen Hopkins theory, doesn&#8217;t it? So today we will take our metrics, put them in the DeLorean and make them travel back in time and into other dimensions to see what value they correspond to wherever we go. So fasten your seatbelts, because today we will be looking at: Transformations. <\/p>\n","protected":false},"author":2,"featured_media":2250,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[73,72],"class_list":["post-3720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-articulo","tag-microstrategy"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/comments?post=3720"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/2250"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=3720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=3720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=3720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}