{"id":5926,"date":"2022-03-25T06:45:04","date_gmt":"2022-03-25T05:45:04","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=5926"},"modified":"2022-06-15T09:46:39","modified_gmt":"2022-06-15T08:46:39","slug":"live-file-connection-on-microstrategy","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/live-file-connection-on-microstrategy\/","title":{"rendered":"MicroStrategy Live File Connection"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5926\" class=\"elementor elementor-5926 elementor-5925\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d32b5ac elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"d32b5ac\" 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-c1dc6d3\" data-id=\"c1dc6d3\" 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-911012a elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"911012a\" 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\/Live-file-conncetion.jpg\" class=\"attachment-full size-full wp-image-5982\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Live-file-conncetion.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Live-file-conncetion-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Live-file-conncetion-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Live-file-conncetion-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Live-file-conncetion-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 Live File Connection<\/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\/2022\/03\/25\/\">\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>25\/03\/2022<\/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 to everyone! How are my friends and beautiful consulting adventurers doing? See you again in this magical meeting space called <b>#Bestinmicro<\/b>, a space where I will be writing about different topics related to MicroStrategy, its use, best practices, and features to make the most of the tool.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-15869d5 elementor-widget elementor-widget-text-editor\" data-id=\"15869d5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This week I bring you a little secret that very few people know, so I bet you a toaster that you didn&#8217;t know it. Today we will see how to use a file as a data source! But &#8230; watch out! Before you claim my toaster, I&#8217;ll add the secret spice&#8230; the data source, almost in real-time, without having to import files or use ETLs in between!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3782b54 elementor-widget elementor-widget-image\" data-id=\"3782b54\" 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=\"453\" height=\"420\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170350-1.jpg\" class=\"attachment-large size-large wp-image-5959\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170350-1.jpg 453w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170350-1-300x278.jpg 300w\" sizes=\"(max-width: 453px) 100vw, 453px\" 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-e3e390c elementor-widget elementor-widget-heading\" data-id=\"e3e390c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Introduction<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eb43577 elementor-widget elementor-widget-text-editor\" data-id=\"eb43577\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As many of you already know, MicroStrategy provides several alternatives for reading information from files. Let&#8217;s take a quick look.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a843e0 elementor-widget elementor-widget-heading\" data-id=\"9a843e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">1. External Data<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-509d0a8 elementor-widget elementor-widget-text-editor\" data-id=\"509d0a8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This option allows you to import different types of files from disk. Excels, CSV, txt, and even JSON files.<\/p><p>When imported, an in-memory cube will be created that will store the current photo and can be used as a data source. Of course, every time the information requires <span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem;\"><span style=\"font-weight: var( --e-global-typography-text-font-weight );\">refreshment, it must be done<\/span> <b><u>manually<\/u><\/b><span style=\"font-weight: var( --e-global-typography-text-font-weight );\"> to republish the cube, selecting the file and importing it again. That is, this implies<\/span><\/span><\/p><p>&#8211; Whoever republishes the cube must have access to the latest version of the file.<\/p><p>&#8211; Every time you want to refresh the cube, you must do it manually.<\/p><p>&#8211; There is no guarantee that the information you see in MicroStrategy is the latest information in Excel.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bafd513 elementor-widget elementor-widget-image\" data-id=\"bafd513\" 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=\"599\" height=\"212\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170410-1.jpg\" class=\"attachment-large size-large wp-image-5957\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170410-1.jpg 599w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170410-1-300x106.jpg 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" 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-961e966 elementor-widget elementor-widget-heading\" data-id=\"961e966\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">2. MicroStrategy Office<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-acd7689 elementor-widget elementor-widget-text-editor\" data-id=\"acd7689\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"text-align: justify;\">The MicroStrategy for Office add-in allows you to use Microsoft Excel to connect to data in MicroStrategy.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c2b02de elementor-widget elementor-widget-image\" data-id=\"c2b02de\" 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=\"356\" height=\"212\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170421-1.jpg\" class=\"attachment-large size-large wp-image-5955\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170421-1.jpg 356w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170421-1-300x179.jpg 300w\" sizes=\"(max-width: 356px) 100vw, 356px\" 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-75106f9 elementor-widget elementor-widget-text-editor\" data-id=\"75106f9\" 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 );\">The initial version of the add-in features the ability to import and update MicroStrategy reports and datasets to Microsoft Excel.<\/span><\/p><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 );\">Of course, this goes in the opposite direction to what we are proposing here, it would be to access MicroStrategy from Excel, and not the other way around. In addition, this applies only to office. So, let&#8217;s go<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e03bee9 elementor-widget elementor-widget-video\" data-id=\"e03bee9\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/LUYc9Jof03s&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-bf3d8da elementor-widget elementor-widget-heading\" data-id=\"bf3d8da\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">3. Live data from repository<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53a3294 elementor-widget elementor-widget-text-editor\" data-id=\"53a3294\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>And this is where I bet the toaster. There is an option, within the import data, which is to import data by URL.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f96beb1 elementor-widget elementor-widget-image\" data-id=\"f96beb1\" 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=\"438\" height=\"320\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170436-1.jpg\" class=\"attachment-large size-large wp-image-5953\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170436-1.jpg 438w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170436-1-300x219.jpg 300w\" sizes=\"(max-width: 438px) 100vw, 438px\" 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-4ab7318 elementor-widget elementor-widget-text-editor\" data-id=\"4ab7318\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>If you look at the description, you will see that these are the same types of files as the option we mentioned before, only this time the data comes from FTP or web. And this is where the magic is.<\/p><p>Do not panic if the first thing you see is that this option is disabled. First, you need to enable data import as shown here:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cac267 elementor-widget elementor-widget-image\" data-id=\"5cac267\" 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=\"581\" height=\"427\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170449-1.jpg\" class=\"attachment-large size-large wp-image-5951\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170449-1.jpg 581w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170449-1-300x220.jpg 300w\" sizes=\"(max-width: 581px) 100vw, 581px\" 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-00e9834 elementor-widget elementor-widget-text-editor\" data-id=\"00e9834\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Then, we will have to enable the source from which we will bring the data. This part is not very intuitive, because clicking on the general square is not the same as clicking right where it says &#8220;Set allowed URLs&#8221;.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2de76a2 elementor-widget elementor-widget-image\" data-id=\"2de76a2\" 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=\"462\" height=\"359\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170504-1.jpg\" class=\"attachment-large size-large wp-image-5949\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170504-1.jpg 462w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170504-1-300x233.jpg 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" 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-0b63d97 elementor-widget elementor-widget-text-editor\" data-id=\"0b63d97\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>So first, in case you have the file in a SharePoint, a repository, a drive, a Dropbox&#8230; it is a matter of adding it to the whitelist.<\/p><p>In this case, if we want to use a file, we will put it in our intelligence server (or some directory where it has access). For example, here I will create a directory &#8220;temp&#8221; inside C, and inside I will place the file I want to read.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-13b5b40 elementor-widget elementor-widget-image\" data-id=\"13b5b40\" 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=\"462\" height=\"337\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170518-1.jpg\" class=\"attachment-large size-large wp-image-5947\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170518-1.jpg 462w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170518-1-300x219.jpg 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" 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-527e5a7 elementor-widget elementor-widget-text-editor\" data-id=\"527e5a7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Then, when we go to import from URL, this window will appear, where we will be able to choose between adding the path to the directory or browsing<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08a5c39 elementor-widget elementor-widget-image\" data-id=\"08a5c39\" 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=\"574\" height=\"242\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170537-1.jpg\" class=\"attachment-large size-large wp-image-5965\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170537-1.jpg 574w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170537-1-300x126.jpg 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" 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-ded1b01 elementor-widget elementor-widget-text-editor\" data-id=\"ded1b01\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>There we put the directory and we can navigate between the different files available to import and create a cube:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-431c163 elementor-widget elementor-widget-image\" data-id=\"431c163\" 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=\"572\" height=\"322\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170550-1.jpg\" class=\"attachment-large size-large wp-image-5963\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170550-1.jpg 572w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170550-1-300x169.jpg 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" 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-9a9eb8b elementor-widget elementor-widget-text-editor\" data-id=\"9a9eb8b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Here comes the most magical magic of all: we can schedule the refresh of these cubes, and it will not be necessary to manually select the file (as if we did it in the import data).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de287d0 elementor-widget elementor-widget-image\" data-id=\"de287d0\" 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=\"314\" height=\"206\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170607-1.jpg\" class=\"attachment-large size-large wp-image-5961\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170607-1.jpg 314w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-03-24-170607-1-300x197.jpg 300w\" sizes=\"(max-width: 314px) 100vw, 314px\" 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-99ea9b3 elementor-widget elementor-widget-text-editor\" data-id=\"99ea9b3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Then, being able to create a schedule every 1, 5, or 10 minutes (depending on the need, and the weight of the cube) we can have updated information coming from a file without the need to be republishing.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e73a153 elementor-widget elementor-widget-heading\" data-id=\"e73a153\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Conclusion<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f051abe elementor-widget elementor-widget-text-editor\" data-id=\"f051abe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>You tell me if you are the new owners of a toaster. For my part, it is a functionality that came in handy when using data blending when creating dossiers, and I have also used it with hypercards that are fed with information coming from a SharePoint. So I hope you find it useful, and see you next week for another edition!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-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>This week I bring you a little secret that very few people know, so I bet you a toaster that you didn&#8217;t know it. Today we will see how to use a file as a data source! But &#8230; watch out! Before you claim my toaster, I&#8217;ll add the secret spice&#8230; the data source, almost in real-time, without having to import files or use ETLs in between!<\/p>\n","protected":false},"author":2,"featured_media":5982,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[71],"class_list":["post-5926","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\/5926","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=5926"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/5926\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/5982"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=5926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=5926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=5926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}