{"id":4644,"date":"2021-09-03T05:00:59","date_gmt":"2021-09-03T04:00:59","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=4644"},"modified":"2021-10-25T09:01:26","modified_gmt":"2021-10-25T08:01:26","slug":"microstrategy-fact-tables-in-queries-2","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-fact-tables-in-queries-2\/","title":{"rendered":"MicroStrategy Definition of Fact Tables in queries"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"4644\" class=\"elementor elementor-4644 elementor-4643\" 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\/fact-tables-banner.jpg\" class=\"attachment-full size-full wp-image-4712\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/fact-tables-banner.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/fact-tables-banner-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/fact-tables-banner-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/fact-tables-banner-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/fact-tables-banner-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 Definition of Fact Tables in queries<\/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\/09\/03\/\">\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>03\/09\/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>Good morning everyone again! One more week that finds us in our warm and entertaining little corner of <i>#BestInMicro<\/i>!<\/p>\n<p>This week we return with a new story lived in the flesh, one of those that give you support to the experience as a consultant, one of those that you learn when you live them.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cce712 elementor-widget elementor-widget-image\" data-id=\"5cce712\" 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=\"400\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162452.jpg\" class=\"attachment-large size-large wp-image-4668\" alt=\"Fact Tables\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162452.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162452-300x150.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162452-768x384.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-b8954ec elementor-widget elementor-widget-text-editor\" data-id=\"b8954ec\" 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 );\">In my case, it was a situation that I knew how to solve (I don&#8217;t remember if it is because it happened to me or if I learned it from reading the manuals), but it is a situation that is not common to see and I thought it was appropriate to tell you about it. This week I am going to tell you how we can control which tables will dominate the queries when creating reports in MicroStrategy.<\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e386f9f elementor-widget elementor-widget-heading\" data-id=\"e386f9f\" 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-cd1541e elementor-widget elementor-widget-text-editor\" data-id=\"cd1541e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Let&#8217;s start from the beginning. As we have already repeated several times, MicroStrategy is basically a tool that allows you to generate and execute queries without the need to understand SQL. That is, we drag a couple of attributes, some metrics, and some filter&#8230; and voila, we have our data. We can go to the little button that shows us the SQL query that was generated&#8230; but everything is automatic. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db3d9de elementor-widget elementor-widget-text-editor\" data-id=\"db3d9de\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Logically, MicroStrategy does not invent which tables the information comes from, everything is previously defined in the semantic layer that characterizes the tool, so we know that most of the objects will have an associated table. For example, an attribute will have an ID associated with the main table (of facts) and another dimension table that will have the description of that attribute (a lookup table).<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7342766 elementor-widget elementor-widget-image\" data-id=\"7342766\" 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=\"404\" height=\"304\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162511.jpg\" class=\"attachment-large size-large wp-image-4670\" alt=\"Fact Tables Snowflake\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162511.jpg 404w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162511-300x226.jpg 300w\" sizes=\"(max-width: 404px) 100vw, 404px\" 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-f88f211 elementor-widget elementor-widget-text-editor\" data-id=\"f88f211\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In a simple model, we have a Snowflake model&#8230; basically a table of facts and their multiple associated dimensions. But when we go into slightly larger models, we will see that there are several fact tables involved in our model&#8230;.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6152c10 elementor-widget elementor-widget-text-editor\" data-id=\"6152c10\" 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 );\">And this is where it gets complicated. Let&#8217;s take a simple example: if we have a fact table that records purchases and another one that records sales, in both we will have the column &#8220;PRODUCT_ID&#8221;. But if we want to make a query that lists the products we sell, MicroStrategy should generate the query on the sales table&#8230; but how do we make it bring us ONLY the ones in this table, and not bring us all the products we have in the catalog? Or those on the shopping table?<\/span><\/p>\n<p>I know, maybe that&#8217;s a pretty generic example, but I think you get the idea. So, here&#8217;s the question:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9a682e elementor-widget elementor-widget-heading\" data-id=\"f9a682e\" 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-0c89adc elementor-widget elementor-widget-text-editor\" data-id=\"0c89adc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In the case of attributes, the question is simple: the table is defined as a lookup table. Easy, isn&#8217;t it?<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e5e8794 elementor-widget elementor-widget-image\" data-id=\"e5e8794\" 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=\"563\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162532.jpg\" class=\"attachment-large size-large wp-image-4672\" alt=\"Fact Tables Attribute Editor\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162532.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162532-300x211.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162532-768x540.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-99be911 elementor-widget elementor-widget-text-editor\" data-id=\"99be911\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>But&#8230; If I only want to show the ID in the report, will it always go to the lookup table? What if we add an indicator? What if it is a heterogeneous ID? Who tells me where it would go in this case?&#8230; <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dffae92 elementor-widget elementor-widget-image\" data-id=\"dffae92\" 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=\"560\" height=\"587\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162549.jpg\" class=\"attachment-large size-large wp-image-4674\" alt=\"Fact Tables Attribute\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162549.jpg 560w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162549-286x300.jpg 286w\" sizes=\"(max-width: 560px) 100vw, 560px\" 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-f0f7a42 elementor-widget elementor-widget-text-editor\" data-id=\"f0f7a42\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Well, there is no fixed answer. At least not generic, but today I will explain two ways to define an answer to this question.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-98290fb elementor-widget elementor-widget-heading\" data-id=\"98290fb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">1- Table logical Size<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-96c19c2 elementor-widget elementor-widget-text-editor\" data-id=\"96c19c2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>All tables have information, and the more information you have, and the less indexed it is, the more time it will take to get the information from that table. This is why each table has a certain &#8220;weight&#8221;. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eb2a80a elementor-widget elementor-widget-text-editor\" data-id=\"eb2a80a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>If we go to the properties of a table in MicroStrategy, we will see that there is a field indicating the weight of that table. This affects the time to inquire. MicroStrategy will try to define the query using the &#8220;lightest&#8221; tables. This may even lead MicroStrategy&#8217;s Query engine to prefer to do several nested joins, jumping through different tables rather than query a single aggregate table. <a href=\"https:\/\/community.microstrategy.com\/s\/article\/How-are-the-fact-tables-determined-using-the-logical-table-size-for-SQL-generation-in-MicroStrategy?language=en_US\" target=\"_blank\" rel=\"noopener\">This note<\/a> explains a bit about what factors affect the weight of each table. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0bc549d elementor-widget elementor-widget-image\" data-id=\"0bc549d\" 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=\"655\" height=\"666\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162603.jpg\" class=\"attachment-large size-large wp-image-4676\" alt=\"Table Logical Size\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162603.jpg 655w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162603-295x300.jpg 295w\" 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-82fe2f9 elementor-widget elementor-widget-text-editor\" data-id=\"82fe2f9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Care must be taken to modify this value. When updating the schema (or restarting the IS, logically), these values are recalculated. Except selecting the checkbox below the weight, but do so with the understanding that this leads to manual maintenance of the table and may harm the overall performance. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9e72d1 elementor-widget elementor-widget-text-editor\" data-id=\"f9e72d1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>But we already know each other, and here we like to make things scalable and a bit simpler. That is why, instead of playing with the weights of the tables, we will focus on the indicators that manage the tables. So we move on to the next point:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cb62da elementor-widget elementor-widget-heading\" data-id=\"5cb62da\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">2- Metric Parameters<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73c73fa elementor-widget elementor-widget-text-editor\" data-id=\"73c73fa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As we already know here, what really affects a query is the fact table. And what objects do they mainly read from this one? Of course, indicators! This is why we can generate an impact from the metrics editor. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3449519 elementor-widget elementor-widget-text-editor\" data-id=\"3449519\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Have you noticed that if you hover over the formula, an option called &#8220;Parameters&#8221; appears? Here we can define certain properties that will impact the query.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e6356e8 elementor-widget elementor-widget-image\" data-id=\"e6356e8\" 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=\"561\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162620.jpg\" class=\"attachment-large size-large wp-image-4678\" alt=\"Metric Parameters\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162620.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162620-300x210.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162620-768x539.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-e6b424a elementor-widget elementor-widget-text-editor\" data-id=\"e6b424a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Within these options, there is one called &#8220;FactID&#8221;. En esta podemos definir qu\u00e9 fact nos interesa que priorice la f\u00f3rmula o la consulta. Recall that a fact represents a column in a table. That is, we can indicate that we prefer to try to do the calculation based on a column of a particular table in our model.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2494d12 elementor-widget elementor-widget-image\" data-id=\"2494d12\" 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=\"514\" height=\"377\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162633.jpg\" class=\"attachment-large size-large wp-image-4680\" alt=\"Count Parameters\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162633.jpg 514w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2021-09-02-162633-300x220.jpg 300w\" sizes=\"(max-width: 514px) 100vw, 514px\" 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-e64bf83 elementor-widget elementor-widget-text-editor\" data-id=\"e64bf83\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>We will see this much clearer in the video, where we can see an example with different indicators and how is the difference between them, how it changes the query and the result.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1684898 elementor-widget elementor-widget-video\" data-id=\"1684898\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=si0P4ovx_JU&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-5b149c8 elementor-widget elementor-widget-text-editor\" data-id=\"5b149c8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>What do you say? Do you know of any other way? Surely some <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-vldb\/\" target=\"_blank\" rel=\"noopener\">VLDB property<\/a> has something to tell around here?<\/p>\n<p>Anyway, I hope this is clear. As always, I leave you several links where you can find more information, and if you have any doubts, you can ask me here below! Espero que les haya sido de utilidad, \u00a1y hasta la pr\u00f3xima!<\/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\">Sources<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f423fe3 elementor-widget elementor-widget-text-editor\" data-id=\"f423fe3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"http:\/\/certificacionmicrostrategy.blogspot.com\/2016\/02\/trabajando-con-atributos.html\" target=\"_blank\" rel=\"noopener\">Microstrategy Certification: Working with Attributes (certificacionmicrostrategy.blogspot.com)<\/a><\/p>\n<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/How-are-the-fact-tables-determined-using-the-logical-table-size-for-SQL-generation-in-MicroStrategy?language=en_US\" target=\"_blank\" rel=\"noopener\">How are the fact tables determined using the logical table size for SQL generation in MicroStrategy<\/a><\/p>\n<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB8983-What-is-the-Attribute-weights-setting-in-MicroStrategy?language=en_US\" target=\"_blank\" rel=\"noopener\">KB8983: What is the \u201cAttribute weights\u201d setting in MicroStrategy Developer 9.x<\/a><a style=\"background-color: #ffffff; font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" href=\"https:\/\/community.microstrategy.com\/s\/article\/KB41812-What-do-each-of-the-Count-parameters-control-in-MicroStrategy-Metric-Editor?language=en_US\" target=\"_blank\" rel=\"noopener\">KB41812: What do each of the Count parameters control in MicroStrategy Metric Editor<\/a><\/p>\n<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB41812-What-do-each-of-the-Count-parameters-control-in-MicroStrategy-Metric-Editor?language=en_US\" target=\"_blank\" rel=\"noopener\">KB19708: How to design a metric that counts attribute elements from a fact table instead of a lookup table in MicroStrategy Developer 9.4.x &#8211; 10.x<\/a><\/p>\n<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB41812-What-do-each-of-the-Count-parameters-control-in-MicroStrategy-Metric-Editor?language=en_US\" target=\"_blank\" rel=\"noopener\">KB41812: What do each of the Count parameters control in MicroStrategy Metric Editor<\/a><\/p>\n<p>Project Design Guide \u2013 Logical Tables Chapter<\/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-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-c77df54 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"c77df54\" 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>Esta semana volvemos con una nueva historia vivida en carne propia, de estas que te dan respaldo a la experiencia como consultor, de aquellas que se aprende cuando uno las vive. <\/p>\n<p>In my case, it was a situation that I knew how to solve, but it is a situation that is not common to see and I thought it was appropriate to tell you about it. This week I am going to tell you how we can control which tables will dominate the queries when creating reports in MicroStrategy.<\/p>\n","protected":false},"author":2,"featured_media":4712,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[72],"class_list":["post-4644","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-microstrategy"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/4644","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=4644"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/4644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/4712"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=4644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=4644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=4644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}