{"id":3756,"date":"2021-04-30T07:00:10","date_gmt":"2021-04-30T06:00:10","guid":{"rendered":"https:\/\/bestdatasolutions.es\/microstrategy-report-caching-vs-history-list\/"},"modified":"2021-07-06T10:11:46","modified_gmt":"2021-07-06T09:11:46","slug":"microstrategy-report-caching-vs-history-list","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-report-caching-vs-history-list\/","title":{"rendered":"MicroStrategy Report Caching vs History List"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3756\" class=\"elementor elementor-3756 elementor-2128\" 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-Report-Caching-vs-History-List.jpg\" class=\"attachment-full size-full wp-image-2254\" alt=\"MicroStrategy: Report Caching vs History List\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Report-Caching-vs-History-List.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Report-Caching-vs-History-List-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Report-Caching-vs-History-List-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Report-Caching-vs-History-List-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Report-Caching-vs-History-List-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 Report Caching vs History List<\/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\/30\/\">\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>30\/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-966ed4e 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=\"966ed4e\" 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><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">Talking a bit about optimization techniques, today I come to talk a bit about two very similar functionalities within the tool. Basic for any user, and it is still worth highlighting their importance, similarities, differences, and also their risks, since they jeopardize the veracity of the information displayed. Today, face to face and head to head, I bring you the first fight of the season: Caches vs History list. <\/span><\/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\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/elementor\/thumbs\/report-caching-vs-history-list-p8ouxeoirlvif4gno58mwm9xlri9ug5lj5y3np9ros.jpg\" title=\"Report Caching vs History List\" alt=\"report-caching-vs-history-list\" loading=\"lazy\" \/>\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-ce626bd elementor-widget elementor-widget-text-editor\" data-id=\"ce626bd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Perhaps many have heard of either, both, or neither, but the number of users I see re-running the same reports over and over again, many complaining about the delays involved, is far greater than they realize: Caches vs History list. And while we&#8217;re on the subject, let&#8217;s introduce the opponents&#8230; <\/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\">History List<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4028de2 elementor-widget elementor-widget-text-editor\" data-id=\"4028de2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>You may have noticed that, in the home of each project, by default, we have (in addition to shared reports, my reports, etc) a directory called &#8220;History List&#8221;. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-34855f5 elementor-widget elementor-widget-image\" data-id=\"34855f5\" 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=\"772\" height=\"376\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list.jpg\" class=\"attachment-large size-large wp-image-2171\" alt=\"History List\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list.jpg 772w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list-300x146.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list-768x374.jpg 768w\" sizes=\"(max-width: 772px) 100vw, 772px\" 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-68e09a2 elementor-widget elementor-widget-text-editor\" data-id=\"68e09a2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This is a repository of pre-executed reports and documents. What do I mean by that? It&#8217;s simple. MicroStrategy gives us the option to send an object to the &#8220;history list&#8221; instead of waiting for it to finish.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e04aee elementor-widget elementor-widget-image\" data-id=\"1e04aee\" 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=\"589\" height=\"280\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/imagen-history-list.jpg\" class=\"attachment-large size-large wp-image-2175\" alt=\"History List Image\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/imagen-history-list.jpg 589w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/imagen-history-list-300x143.jpg 300w\" sizes=\"(max-width: 589px) 100vw, 589px\" 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-54b0653 elementor-widget elementor-widget-text-editor\" data-id=\"54b0653\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>When a report is sent to the history list, it continues to run in the background and is stored in the history. So when we want to check the result, we can go to the folder, and there we will find the report already executed. <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">This type of action is vital when running reports that take a long time to execute,<\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">where there is a risk that there is a connection timeout and what is being executed is lost. When we send a report or a document to the history, it will continue to run until it is finished regardless of whether we log off, log out or continue working with other reports. <\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">The important thing to understand here is that when you send a report to the history, it is as if you were taking a picture of it totally independent of the rest of the objects. That is, if they run a document and send it to history, they can then take the document and modify it, delete it or change the information it displays. But when they go to the history, the version they will find is exactly the one that existed when they clicked on it in the first place. <\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">And this is why each history message (that&#8217;s how each object we send is called) has its date and time. If you send the same report or document to history twice, instead of being overwritten, two different records will be created (it is possible to define a limit of records per the report, but we are talking generically). <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bfcb9a8 elementor-widget elementor-widget-image\" data-id=\"bfcb9a8\" 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=\"136\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list-microstrategy-tutorial.jpg\" class=\"attachment-large size-large wp-image-2178\" alt=\"History List Microstrategy Tutorial\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list-microstrategy-tutorial.jpg 934w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list-microstrategy-tutorial-300x51.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/history-list-microstrategy-tutorial-768x131.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-c7fe975 elementor-widget elementor-widget-heading\" data-id=\"c7fe975\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Caches<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5d36c64 elementor-widget elementor-widget-text-editor\" data-id=\"5d36c64\" 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 straightforward definition, &#8220;A cache is a set of results that are stored in a system to improve response time on future requests.&#8221; <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">Microstrategy has different types of cache, but at this time we will focus only on the report cache, and in the future, I will go into detail on how the different types of cache work in the tool. <\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">With caching, users can retrieve results stored in files on the Intelligence Server instead of re-running queries against a database. This means that when you run a report that has a cache associated with it, instead of running the report and waiting for it to finish, the information comes out almost instantly. <\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">The cache is created when the report is run for the first time. Here, the report takes as long as it takes to generate, but it generates a cache, so the next time it is run instead of querying against the warehouse, the stored result will be displayed directly.<\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-91814d7 elementor-widget elementor-widget-image\" data-id=\"91814d7\" 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=\"460\" height=\"403\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/report-caching.jpg\" class=\"attachment-large size-large wp-image-2182\" alt=\"Report Caching Microstrategy\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/report-caching.jpg 460w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/report-caching-300x263.jpg 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" 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-5522557 elementor-widget elementor-widget-text-editor\" data-id=\"5522557\" 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, for a report to store caches, it must be enabled. At the project level, a default behavior can be defined, but it can also be defined at the report level. <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f20c08 elementor-widget elementor-widget-image\" data-id=\"2f20c08\" 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=\"213\" height=\"223\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/report-caching-microstrategy.jpg\" class=\"attachment-large size-large wp-image-2186\" alt=\"Report Caching MicroStrategy\" 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-0a1c55b elementor-widget elementor-widget-heading\" data-id=\"0a1c55b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">What do you have in common?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-202622c elementor-widget elementor-widget-text-editor\" data-id=\"202622c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As you can imagine, both methods help us to optimize the performance and response time of the reports that a user runs. Their ultimate purpose is to improve the response time of a query in subsequent requests. <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">If we go to a more technical level, history is closely related to caching functionality. If you think about it, history is made up of messages that point to report results, and these are stored as &#8220;history caches&#8221;. Therefore, when a message is deleted from the History list, the History cache to which the message points is also deleted. <\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">Returning to what applies to functionality, both can be generated at the time of execution as well as planned. <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c64f589 elementor-widget elementor-widget-image\" data-id=\"c64f589\" 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=\"307\" height=\"359\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/report-caching-update.jpg\" class=\"attachment-large size-large wp-image-2190\" alt=\"Report Caching Update\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/report-caching-update.jpg 307w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/report-caching-update-257x300.jpg 257w\" sizes=\"(max-width: 307px) 100vw, 307px\" 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-ec3f982 elementor-widget elementor-widget-text-editor\" data-id=\"ec3f982\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>For example, if I wanted a report (let&#8217;s say it takes 2 hours to finish) to run automatically at 6 am to have the data from the previous day, it is scheduled at that time so that when I get to the office at 8 am the report is ready and in a matter of seconds I can already be running it within the tool, so we can use display filters or create documents and graphics based on that report without having to wait for it to run every time&#8230; sounds interesting, doesn&#8217;t it? <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">And in the same way, both can be assigned validity. In other words, there may be a period of validity in which they can be used. <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-61a2bb4 elementor-widget elementor-widget-heading\" data-id=\"61a2bb4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">What is the difference?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c7f6397 elementor-widget elementor-widget-text-editor\" data-id=\"c7f6397\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This is where the important part of the issue comes in. There are several points to consider that differentiate one from the other. <\/p>\n<ul>\n<li><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem;\"><b>Accessibility<\/b><\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">When a cache is created, it is used by all users running the report. For example, if John runs report &#8220;A&#8221; and then I run it, I will be able to take advantage of the cache that was generated in the first execution. In contrast, history messages are personal and will only be accessible by those users who execute them. <\/span><\/li>\n<li><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem;\"><b>Management and maintenance:<\/b><\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"> As I mentioned earlier, there are different types of caches. There are many options to manage and administer the use of caches, while the history is a bit more limited in this regard. Anyway, following on from the previous line, this makes sense as caches are much more global. <\/span><\/li>\n<li><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem;\"><b>Versatility:<\/b><\/span><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"> A cache can be reused in documents, reports, users, etc. If a report has any filters, different caches are generated for each of the filters (actually, for each variation of the SQL, so variations also apply at the security level). If we switch from one filter to the other, since both options are cached, the performance will remain optimal, while the history list will re-execute the report. <\/span><\/li>\n<li><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem;\"><b>Administration:<\/b><\/span> <span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">While the history is personal to each user, the caches are managed by the platform administrators.<\/span> <\/li>\n<li><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem;\"><b>Validity:<\/b><\/span> <span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">If a report, indicator, filter, attribute, or any other object related to a report is modified, the cache automatically becomes invalid.<\/span> <\/li>\n<\/ul>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ddcf993 elementor-widget elementor-widget-heading\" data-id=\"ddcf993\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">When is it convenient to use each one? <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc720e0 elementor-widget elementor-widget-text-editor\" data-id=\"cc720e0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As you can imagine, there are different scenarios, and depending on each one it is convenient (or possible) to use each one. <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">In general, conditions, if a report is used massively, perhaps enabling caches is ideal, while if what you are interested in is to have the photo of the specific moment personally to analyze it later, or to make sure that the report will not be interrupted in any eventuality, then sending it to the history is enough. <\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">The truth is that you have to be very careful with both. As I said before, a cache can be invalidated if something is changed in the objects or Query related to the report, but if the data is updated, there is nothing to indicate it, so they may be visualizing and analyzing old data&#8230; and that can have a huge impact in many cases. So you know, watch out! <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e717ddf elementor-widget elementor-widget-heading\" data-id=\"e717ddf\" data-element_type=\"widget\" data-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-e24cab9 elementor-widget elementor-widget-text-editor\" data-id=\"e24cab9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As I said before, at the end of the day, these are two ways that MicroStrategy provides to optimize the execution of reports. Both are complementary, i.e., it is not that you have to choose between one option and the other, but that each user and each project will choose based on their own needs. <\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">Let me know what you think, did you know about both methods, which one do you use more often, are there any features you didn&#8217;t know about that I am missing? <\/span><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">I hope you found it useful! See you next time! <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-39b13b3 elementor-widget elementor-widget-heading\" data-id=\"39b13b3\" data-element_type=\"widget\" data-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.5\/manuals\/en\/AdvancedReporting.pdf\" target=\"_blank\" rel=\"noopener\">MicroStrategy Advanced report Guide \u2013 Caching chapter&nbsp;<\/a><\/p>\n<p><span style=\"font-family: var( --e-global-typography-text-font-family ); font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\"><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.4\/manuals\/en\/Admin.pdf\" target=\"_blank\" rel=\"noopener\">MicroStrategy System Administrator Guide \u2013 history List chapter&nbsp;<\/a><\/span><\/p>\n<p><a href=\"http:\/\/sujitkumars.blogspot.com\/2017\/05\/different-type-of-caches-available-in.html\" target=\"_blank\" rel=\"noopener\">Different type of Caches Available in Microstrategy<\/a><\/p>\n<p><a href=\"http:\/\/microstrategyanalytics.blogspot.com\/2019\/01\/microstrategy-caches-explained.html\" target=\"_blank\" rel=\"noopener\">Microstrategy Caches explained<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-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-11e5e81 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"11e5e81\" 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>Talking a bit about optimization techniques, today I come to talk a bit about two very similar functionalities within the tool. Basic for any user, and it is still worth highlighting their importance, similarities, differences, and also their risks, since they jeopardize the veracity of the information displayed. Today, face to face and head to head, I bring you the first fight of the season: Caches vs History list. <\/p>\n","protected":false},"author":2,"featured_media":2254,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[73,72],"class_list":["post-3756","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\/3756","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=3756"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3756\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/2254"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=3756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=3756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=3756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}