{"id":3763,"date":"2021-04-09T10:08:00","date_gmt":"2021-04-09T09:08:00","guid":{"rendered":"https:\/\/bestdatasolutions.es\/microstrategy-grouping-methods\/"},"modified":"2021-07-28T10:53:59","modified_gmt":"2021-07-28T09:53:59","slug":"microstrategy-grouping-methods","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-grouping-methods\/","title":{"rendered":"MicroStrategy Grouping Methods"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3763\" class=\"elementor elementor-3763 elementor-2431\" 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\">\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\">\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-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-Grouping-Methods-1.jpg\" class=\"attachment-full size-full wp-image-2438\" alt=\"MicroStrategy Grouping Methods\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Grouping-Methods-1.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Grouping-Methods-1-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Grouping-Methods-1-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Grouping-Methods-1-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Grouping-Methods-1-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\">\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\">\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-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-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\">\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-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">MicroStrategy Grouping Methods<\/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-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\/04\/09\/\">\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>09\/04\/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-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-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Hello everyone! How is it going? Welcome back, another week, to this magical and beautiful section of <i>#BestInMicro<\/i>!<\/p>\n<p>This week I bring you an adventure of my colleague Juan Valladares. We received an incident from a user complaining about how long a report was taking to run. While many factors affect the <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-report-caching-vs-history-list\/\">performance of a report<\/a> (I will write about them at some point), we found that in this particular case it was a problem with the design of the report itself.<\/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-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"303\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstraregy-loading.jpg\" class=\"attachment-full size-full wp-image-2456\" alt=\"MicroStrategy Loading\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstraregy-loading.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstraregy-loading-300x114.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstraregy-loading-768x291.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" 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-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>We noticed that the user wanted to analyze his result by grouping it into different categories, and for this, he had created a custom group with each of them.<\/p>\n<p>Many of you will think&#8230; logical, isn&#8217;t it? Well, not so much. As I told you in the video explaining the different types of filters we have, there are different ways of grouping data in MicroStrategy, and depending on the scenario and needs, each of these ways will be appropriate.<\/p>\n<p>As always, let&#8217;s start at the beginning&#8230;<\/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-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">How much can the data be grouped?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-625d767 elementor-widget elementor-widget-text-editor\" data-id=\"625d767\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Data grouping in MicroStrategy allows us to generate a set based on different conditions. For example, group months into seasons, zones into regions, or different categories at &#8230;.. well, more general categories.<\/p>\n<p>The groupings are not only tied to a particular attribute but, given the situation, we may want a group that results from a combination of different filters, attributes, and conditions (for example, users from Argentina aged 18 to 24). <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-301232e elementor-widget elementor-widget-heading\" data-id=\"301232e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">MicroStrategy Grouping Types<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9daeee elementor-widget elementor-widget-text-editor\" data-id=\"a9daeee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Therefore, there are three different ways of grouping information in MicroStrategy. Let&#8217;s take a look at each of them.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7d9d048 elementor-widget elementor-widget-heading\" data-id=\"7d9d048\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Derived Elements <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73e2e08 elementor-widget elementor-widget-image\" data-id=\"73e2e08\" data-element_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=\"66\" height=\"97\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Microstrategy-grouping-methods.jpg\" class=\"attachment-full size-full wp-image-2453\" alt=\"MicroStrategy Grouping Methods\" 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-f139058 elementor-widget elementor-widget-text-editor\" data-id=\"f139058\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Perhaps a simple way to understand derived elements is to think of a derived metric. That is, we take an indicator and use it to make a new indicator by taking the original and applying some operation to it, be it a filter, a sum, or some other formula. With derived elements, we can create sets with our attributes, either by selecting several and grouping them, generating some calculation between them, or applying some condition. A derived element allows us to group on the basis of:<\/p>\n<p>&#8211; List of elements<\/p>\n<p>&#8211; Calculations<\/p>\n<p>&#8211; Filters<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b81f4a3 elementor-widget elementor-widget-image\" data-id=\"b81f4a3\" data-element_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=\"296\" height=\"168\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-derived-elements.jpg\" class=\"attachment-full size-full wp-image-2465\" alt=\"Grouping Methods Derived Elements\" 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-0321859 elementor-widget elementor-widget-text-editor\" data-id=\"0321859\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">For example, we create a group that is &#8220;East Zone&#8221; and generate a list of regions that are in the east zone. <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab2530a elementor-widget elementor-widget-image\" data-id=\"ab2530a\" data-element_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=\"601\" height=\"493\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-web-grouping-methods.jpg\" class=\"attachment-full size-full wp-image-2485\" alt=\"Microstrategy Web Grouping Methods\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-web-grouping-methods.jpg 601w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-web-grouping-methods-300x246.jpg 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" 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-19cf66e elementor-widget elementor-widget-text-editor\" data-id=\"19cf66e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Derived elements are available only from MicroStrategy web. That is, we will not be able to create these elements using the Developer.<\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">A simple way to create a derived element is to right-click on the attribute and select &#8220;derived elements&#8221;, or simply, with the report running, select the values you are interested in grouping and right-click- &gt; Create group. Ready! <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35e86c9 elementor-widget elementor-widget-image\" data-id=\"35e86c9\" data-element_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=\"205\" height=\"367\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-derived-elements-image.jpg\" class=\"attachment-full size-full wp-image-2462\" alt=\"Grouping Methods Derived Element Image\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-derived-elements-image.jpg 205w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-derived-elements-image-168x300.jpg 168w\" sizes=\"(max-width: 205px) 100vw, 205px\" 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-5c3c6c2 elementor-widget elementor-widget-heading\" data-id=\"5c3c6c2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Consolidation<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42db899 elementor-widget elementor-widget-image\" data-id=\"42db899\" data-element_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=\"79\" height=\"72\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-image.jpg\" class=\"attachment-full size-full wp-image-2459\" alt=\"Grouping Methods 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-4b22f73 elementor-widget elementor-widget-text-editor\" data-id=\"4b22f73\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Consolidations are a combination of values of one or more attributes that can be combined to generate a group. We can create groupings with:<\/p>\n<p>\u2022<span style=\"white-space:pre\"> <\/span>Elements of the same attribute, such as two cities.<\/p>\n<p>\u2022<span style=\"white-space:pre\"> <\/span>Attributes of different levels of the same hierarchy, such as Region and Province.<\/p>\n<p>\u2022<span style=\"white-space:pre\"> <\/span>Attribute elements from different hierarchies, such as Country (from the Geography hierarchy) and Year (from the Time hierarchy).<\/p>\n<p>\u2022<span style=\"white-space:pre\">Existing consolidation elements, such as the relationship between spring and summer sales and fall and winter sales.<\/span><\/p>\n<p>\u2022<span style=\"white-space:pre\"> <\/span>Elements of any other consolidation in the project (elements imported from one existing consolidation to another).<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b5abf6 elementor-widget elementor-widget-image\" data-id=\"7b5abf6\" data-element_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=\"800\" height=\"386\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-consolidation-editor.jpg\" class=\"attachment-full size-full wp-image-2474\" alt=\"Grouping Methods Consolidation Editor\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-consolidation-editor.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-consolidation-editor-300x145.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-consolidation-editor-768x371.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" 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-6ad4b60 elementor-widget elementor-widget-text-editor\" data-id=\"6ad4b60\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Unlike derived elements, consolidations can be created only in the Developer, and their creation is quite simple as well. We simply define the groupings we are interested in combining and we can use it as another attribute. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efcbbb2 elementor-widget elementor-widget-heading\" data-id=\"efcbbb2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Customized Groups<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3217249 elementor-widget elementor-widget-image\" data-id=\"3217249\" data-element_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=\"80\" height=\"74\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-custom-groups.jpg\" class=\"attachment-full size-full wp-image-2471\" alt=\"Grouping Methods Custom Groups\" 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-ad18d5e elementor-widget elementor-widget-text-editor\" data-id=\"ad18d5e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>These allow grouping elements of one or different attributes, filters, and\/or conditions to create the group we are interested in generating in our reports. <\/p>\n<p>A customized group is composed of different groups. Each of these groups can have conditions that are totally independent of each other, which allows the generation of totally customized groupings. <\/p>\n<p>The big difference with a customized group is that it has a direct influence when generating the query, so it has a direct impact on performance. If different groups with different conditions are created, the query will have high complexity, with several steps, and may end up resulting in a report that takes hours or even days to resolve.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a9f5af elementor-widget elementor-widget-image\" data-id=\"8a9f5af\" data-element_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=\"642\" height=\"530\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-custom-groups-editor.jpg\" class=\"attachment-full size-full wp-image-2468\" alt=\"Grouping Methods Custom Groups Editor\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-custom-groups-editor.jpg 642w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-custom-groups-editor-300x248.jpg 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" 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-250ae24 elementor-widget elementor-widget-text-editor\" data-id=\"250ae24\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>On the other hand, if you understand how to set up a customized group, the performance may end up being better than using the other methods, in addition to giving you a great deal of flexibility in defining the grouping conditions.<\/p>\n<p>Another great advantage of customized groups is the range of options they offer. Customization can be generated at the level of each group, e.g. presentation of totals and sorting. If you are interested, I can go into detail later and write an article just about custom groups to analyze these aspects.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a95155a elementor-widget elementor-widget-heading\" data-id=\"a95155a\" data-element_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-88d5dfd elementor-widget elementor-widget-text-editor\" data-id=\"88d5dfd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As mentioned above, it depends on each scenario when it is appropriate to use each type of grouping. In the derived elements and consolidations, the calculations are made at an analytical level, that is, they are performed in memory by the Intelligence server, which gives us a better performance when representing the information, but it also has certain limitations and can even end up being counterproductive depending on the complexity of the group. Here is a comparison chart so that you can choose for yourselves which one to use. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f72b91 elementor-widget elementor-widget-image\" data-id=\"1f72b91\" data-element_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=\"800\" height=\"209\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-board.jpg\" class=\"attachment-full size-full wp-image-2477\" alt=\"Grouping Methods Board\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-board.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-board-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/grouping-methods-board-768x201.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" 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-07b3fe1 elementor-widget elementor-widget-text-editor\" data-id=\"07b3fe1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>I hope you found it interesting and that it will help you to continue improving your reporting.<\/p>\n<p>See you next time!<\/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-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-45d0eb9d elementor-widget elementor-widget-text-editor\" data-id=\"45d0eb9d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.4\/manuals\/en\/Admin.pdf\" 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 );\" target=\"_blank\" rel=\"noopener\">MicroStrategy System Administration Guide<\/a><\/p>\n<p><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.4\/WebUser\/WebHelp\/Lang_1033\/Content\/element_group_editor.htm\" target=\"_blank\" rel=\"noopener\">Grouping attribute elements in a dashboard<\/a><\/p>\n<p><a href=\"https:\/\/subscription.packtpub.com\/book\/big_data_and_business_intelligence\/9781789136241\/4\/ch04lvl1sec35\/grouping-data-together-custom-groups-and-consolidations\" 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 );\" target=\"_blank\" rel=\"noopener\">Grouping data together \u2013 Custom Groups and Consolidations<\/a><br><\/p>\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-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-d7dd570 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"d7dd570\" data-element_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 bring you an adventure of my colleague Juan Valladares. We received an incident from a user complaining about how long a report was taking to run. While many factors affect the performance of a report (I will write about them at some point), we found that in this particular case it was a problem with the design of the report itself.<\/p>\n","protected":false},"author":2,"featured_media":2438,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[73,72],"class_list":["post-3763","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\/3763","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=3763"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3763\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/2438"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=3763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=3763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=3763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}