{"id":3907,"date":"2020-10-05T12:03:34","date_gmt":"2020-10-05T11:03:34","guid":{"rendered":"https:\/\/bestdatasolutions.es\/microstrategy-vldb\/"},"modified":"2021-07-15T11:05:01","modified_gmt":"2021-07-15T10:05:01","slug":"microstrategy-vldb","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-vldb\/","title":{"rendered":"MicroStrategy VLDB"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3907\" class=\"elementor elementor-3907 elementor-737\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0a1032c elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"0a1032c\" 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-193ec6b\" data-id=\"193ec6b\" 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-4ec768b elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"4ec768b\" 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-vldb-main.jpg\" class=\"attachment-full size-full wp-image-1106\" alt=\"MicroStrategy VLDB\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-vldb-main.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-vldb-main-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-vldb-main-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-vldb-main-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-vldb-main-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-36745c18 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36745c18\" 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-eca8c7e\" data-id=\"eca8c7e\" 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-4fea62f 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-author-box--link-no elementor-widget elementor-widget-author-box\" data-id=\"4fea62f\" 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-03967a6 elementor-widget elementor-widget-heading\" data-id=\"03967a6\" 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-1e8c404\" data-id=\"1e8c404\" 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-aedd84f elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"aedd84f\" 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 VLDB<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe7fcc4 elementor-widget elementor-widget-post-info\" data-id=\"fe7fcc4\" 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\/2020\/10\/05\/\">\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>05\/10\/2020<\/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-fb756fc 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=\"fb756fc\" 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-0a09409 elementor-widget elementor-widget-text-editor\" data-id=\"0a09409\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>New week, new article: Welcome back to <i>#BestInMicro<\/i>! A place where I will be writing about different topics related to MicroStrategy, its use, best practices, and functionalities to get the most out of the tool. <\/p>\n<p>Today I will go into a topic that is a little more familiar, but at the same time very complex: VLDBs, a set of options as diverse as powerful, which can have a decisive impact when defining them in a project or a particular connection. But let&#8217;s go slowly&#8230;<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5e07a36 elementor-widget elementor-widget-heading\" data-id=\"5e07a36\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">What are VLDB properties?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8473776 elementor-widget elementor-widget-text-editor\" data-id=\"8473776\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>VLDB is an acronym for <i>&#8220;Very Large DataBase&#8221;<\/i>. They allow you to modify the <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-metadata-queries\/\">SQL statement<\/a> generated by MicroStrategy&#8217;s SQL and analytical engine. That is, we can define the order in which operations are performed, optimization level, joins intermediate steps, Hints, and many more things that even go into advanced complexity.&nbsp;<\/p>\n<p>Precise control of these options can have drastic effects on the tool&#8217;s performance (for better and for worse if not used correctly!), so today I&#8217;ll talk a bit about how they work, where and how you can configure them, and some of the most common settings to modify.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b4cf98c elementor-widget elementor-widget-heading\" data-id=\"b4cf98c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Where are they configured? What if I want it to affect a particular report or connection?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c4c25f elementor-widget elementor-widget-text-editor\" data-id=\"3c4c25f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Well, this is an excellent question. This is an example that happened to me a few days ago: By architecture definition, a project has set the default cross between objects to be an inner join type, but for a specific requirement it needed to be an outer join type. While this can be changed at the indicator level, for example, it may have an impact on other reports, so it needs to be defined for this particular report.<\/p>\n<p>Here we encounter a conflict: at the project level we have one definition, but at the report level we have another. Which one rules over which one? Is it possible to define it at different levels?<\/p>\n<p>Yes, it is. There is a priority order for the VLDBs, which is described in the<span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"> <\/span><a style=\"background-color: #ffffff; font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" href=\"https:\/\/community.microstrategy.com\/s\/article\/KB14830-What-are-the-levels-of-VLDB-properties-and-their-order?language=en_US\" target=\"_blank\" rel=\"noopener noreferrer\">KB14830<\/a><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-12fe4bc elementor-widget elementor-widget-image\" data-id=\"12fe4bc\" 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=\"347\" height=\"324\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-1.gif\" class=\"attachment-large size-large wp-image-970\" alt=\"MicroStrategy VLDB Order of Priorities\" 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-4337a17 elementor-widget elementor-widget-text-editor\" data-id=\"4337a17\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Going from the top-down, we start with the <span style=\"font-weight: bold;\">report<\/span> level. This would be the most specific level. All preferences defined at this level (i.e. in each report), will overwrite those defined at lower levels (according to the graphic), but redundantly, they will affect only the report in question. The same applies to <span style=\"font-weight: bold;\">Templates<\/span>. Except for defining a different VLDB property for a particular report, a template can be created to define certain properties that we want to define as a basis when creating a report, without these properties being applied to all new reports (or existing ones, of course!).<\/p>\n<p>Continuing with the hierarchy, we come to the <span style=\"font-weight: bold;\">object-level<\/span> properties. And I know this is where you will tell me: but Joaquin, in the technical note it clearly says &#8220;metric&#8221;! why do you say &#8220;<i>object<\/i>&#8220;? And this is where I explain that at this level not only indicators have VLDB properties, but there are also other objects such as attributes or <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-transformations\/\">transformations.<\/a> So it is important to understand that sometimes adding an attribute to a report can change its behavior about how other attributes are calculated.<\/p>\n<p>Then, we could say that almost simultaneously come <span style=\"font-weight: bold;\">Project<\/span> and <span style=\"font-weight: bold;\">DBI.<\/span> Digo esto porque solo se puede aplicar una instancia de base de datos principal para cada proyecto\u2026 pero dependiendo distintas configuraciones se puede aplicar una u otra DBI. <\/p>\n<p>In addition, the <span style=\"font-weight: bold;\">project-level<\/span> configuration contains VLDB properties related to the MDX reporting and analytical engine. And I add, as a colorful fact, that when modifying a VLDB at this level it is necessary to restart the IS for the changes to take effect.<\/p>\n<p>The most basic <span style=\"font-weight: bold;\">DBMS<\/span> (database) level where properties are defined. It sets the general standards. By default, they are defined by MicroStrategy, optimized for the database and its version.<\/p>\n<p>By default, all properties are governed by the one at the top level. This is reflected in the checkbox <i>&#8220;Use default inherited value for all VLDB properties&#8221;.<\/i> <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a47deae elementor-widget elementor-widget-image\" data-id=\"a47deae\" 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=\"379\" height=\"317\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-2.png\" class=\"attachment-large size-large wp-image-973\" alt=\"MicroStrategy-VLDB-2\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-2.png 379w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-2-300x251.png 300w\" sizes=\"(max-width: 379px) 100vw, 379px\" 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-255fdba elementor-widget elementor-widget-text-editor\" data-id=\"255fdba\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>If the configuration for a VLDB property is edited at the level of a particular object (be it a metric, template, project, etc.), any object above it in the VLDB hierarchy automatically takes the custom configuration as the inherited value.<\/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-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Is it possible to define any VLDB at any level?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd6664e elementor-widget elementor-widget-text-editor\" data-id=\"cd6664e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The truth is that it is not. There are hundreds of different possibilities within the VLDB properties. Many of them are even hidden by default to try to simplify the possibilities, but also to avoid that modifying without understanding what is being done can generate errors of greater impact.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-465c294 elementor-widget elementor-widget-image\" data-id=\"465c294\" 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=\"608\" height=\"220\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-3.png\" class=\"attachment-large size-large wp-image-976\" alt=\"MicroStrategy-VLDB-3\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-3.png 608w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-3-300x109.png 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" 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-0cd4e8b elementor-widget elementor-widget-text-editor\" data-id=\"0cd4e8b\" 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, we also do not have the same options if we define VLDBs at the report level as at the indicator level, for example.<\/p>\n<p>For this reason, I recommend that you analyze well when editing VLDBs to define the bases of a project, or if they are more &#8220;exceptional&#8221; cases, and above all understand the impact that modifying them can have.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fa42e3 elementor-widget elementor-widget-heading\" data-id=\"3fa42e3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Most common examples<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4209aea elementor-widget elementor-widget-text-editor\" data-id=\"4209aea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In the following, I will leave only some of the cases that I have encountered more frequently or that I have also found useful, but remember that, depending on the database, its architecture, the model, etc., what may be optimal in some cases may be very bad for others.<\/p>\n<p><span style=\"font-weight: bold;\"><u>Pre\/Post Statements:<\/u><\/span> This property allows us to inject different sentences or lines of code when attacking the database, and it is distributed by levels, which allows us to say when this code will be executed. This allows us to generate customizations to the executed SQL and if you know where and what to use, you can end up with great performance advantages. Or it can also be as logging, to keep track of what is executed, by whom and analyze the impact it has on the warehouse.<\/p>\n<p>For SQL databases we can add the SQL HINT to this functionality. Below is an example, but the options and variations are endless! How do you use it? Any suggestions?<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e95f36 elementor-widget elementor-widget-image\" data-id=\"3e95f36\" 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=\"724\" height=\"386\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-4.png\" class=\"attachment-large size-large wp-image-979\" alt=\"MicroStrategy-VLDB-4\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-4.png 724w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-4-300x160.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" 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-08c48dc elementor-widget elementor-widget-text-editor\" data-id=\"08c48dc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><u><span style=\"font-weight: bold;\">Metric Join Type:<\/span><\/u> this is one of the most &#8220;popular&#8221;, and its simplicity does not overshadow the impact it generates. It is always good practice to be clear about the best configuration and to define it. By default, it is set to Inner, but I have rarely kept this setting.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ab3834 elementor-widget elementor-widget-image\" data-id=\"3ab3834\" 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=\"473\" height=\"352\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-5.png\" class=\"attachment-large size-large wp-image-982\" alt=\"MicroStrategy-VLDB-5\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-5.png 473w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-5-300x223.png 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" 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-0320bce elementor-widget elementor-widget-text-editor\" data-id=\"0320bce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: bold;\"><u>Default to metric Name<\/u><\/span>: I have found this one useful when analyzing queries. It does not generate any change at the performance level, but it helps a little at the time of having to read queries. If we enable this option, the query will use the indicator name as an alias instead of WJXBFS (Color fact: these are initials of the original SQL Engine developers, according to <a href=\"http:\/\/www.bryanbrandow.com\/2011\/12\/vldb-properties.html\" target=\"_blank\" rel=\"noopener noreferrer\">Bryan Brandow&#8217;<\/a>s blog).<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3d4561 elementor-widget elementor-widget-image\" data-id=\"a3d4561\" 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=\"407\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-6.png\" class=\"attachment-large size-large wp-image-985\" alt=\"MicroStrategy-VLDB-6\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-6.png 514w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-6-300x238.png 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-85aaf94 elementor-widget elementor-widget-text-editor\" data-id=\"85aaf94\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Before:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43a6011 elementor-widget elementor-widget-image\" data-id=\"43a6011\" 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=\"549\" height=\"197\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-7.png\" class=\"attachment-large size-large wp-image-988\" alt=\"MicroStrategy-VLDB-7\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-7.png 549w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-7-300x108.png 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" 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-40de440 elementor-widget elementor-widget-text-editor\" data-id=\"40de440\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Afterwards:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c02e50a elementor-widget elementor-widget-image\" data-id=\"c02e50a\" 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=\"630\" height=\"142\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-8.png\" class=\"attachment-large size-large wp-image-991\" alt=\"MicroStrategy-VLDB-8\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-8.png 630w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-8-300x68.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" 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-cbbf7d6 elementor-widget elementor-widget-text-editor\" data-id=\"cbbf7d6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: bold;\"><u>Cartesian Join Warning<\/u><\/span>: This property is important if, for example, you have users who create reports without having a good understanding of how a query works internally. The fact of having different reports with Cross join can have very big impacts on the performance of the tool and the database, this is why it is a good practice to disable them, and in any case, enable them at report level for particular situations. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd059ad elementor-widget elementor-widget-image\" data-id=\"bd059ad\" 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=\"630\" height=\"311\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-9.png\" class=\"attachment-large size-large wp-image-994\" alt=\"MicroStrategy-VLDB-9\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-9.png 630w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-VLDB-9-300x148.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" 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-516ebae elementor-widget elementor-widget-text-editor\" data-id=\"516ebae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Well, wrapping up this week&#8217;s article. I invite you to look for more information in some sites that I leave below that served as a support for me not to leave anything important out and do not forget to leave me any question or comment, a topic that interests you that I write or that is relevant to you. 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-8fb1b13 elementor-widget elementor-widget-heading\" data-id=\"8fb1b13\" 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.11\/SystemAdmin\/WebHelp\/Lang_1033\/Content\/Details_for_all_VLDB_properties.htm\" 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\">Details for All VLDB Properties<\/a><\/p>\n<p><a href=\"http:\/\/www.microstrategy101.com\/?tag=vldb\" target=\"_blank\" rel=\"noopener\">Calling a Stored Procedure from MicroStrategy<\/a><\/p>\n<p><a href=\"https:\/\/www2.microstrategy.com\/producthelp\/current\/SystemAdmin\/WebHelp\/Lang_1033\/Content\/VLDB%20Settings.htm\" target=\"_blank\" rel=\"noopener\">SQL Generation and Data Processing: VLDB Properties<br \/><\/a><\/p>\n<p><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.11\/SystemAdmin\/WebHelp\/Lang_1033\/Content\/Details_for_all_VLDB_properties.htm\" target=\"_blank\" rel=\"noopener\">Details for All VLDB Properties<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fa56b1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3fa56b1\" 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-1b26bf5 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"1b26bf5\" 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>VLDB is an acronym for &#8220;Very Large DataBase&#8221;. They allow you to modify the SQL statement generated by MicroStrategy&#8217;s SQL and analytical engine. That is, we can define&#8230;<\/p>\n","protected":false},"author":2,"featured_media":1106,"comment_status":"open","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[73,72],"class_list":["post-3907","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\/3907","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=3907"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3907\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/1106"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=3907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=3907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=3907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}