{"id":8176,"date":"2023-10-13T06:37:51","date_gmt":"2023-10-13T05:37:51","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=8176"},"modified":"2024-09-20T13:47:18","modified_gmt":"2024-09-20T12:47:18","slug":"transaction-dossiers","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/transaction-dossiers\/","title":{"rendered":"Transaction Dossiers"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8176\" class=\"elementor elementor-8176 elementor-8175\" 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\/transaction-dossiers.jpg\" class=\"attachment-full size-full wp-image-8217\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-dossiers.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-dossiers-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-dossiers-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-dossiers-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-dossiers-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\">Transaction Dossiers<\/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\/2023\/10\/13\/\">\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>13\/10\/2023<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56263e9 elementor-widget elementor-widget-text-editor\" data-id=\"56263e9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Hello everybody! Once again, here we come with a Transaction dossiers article to expand our universe of tips in our #<em>BestInMicro<\/em> space.<\/p>\n<p>Today we are going to test one of the new (old) functionalities: let&#8217;s see how Transaction Services work in Dossiers! And remember that to know a little more about what they are and how they work, you already have everything described and explained <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-transaction-services\/\">in this article<\/a>.  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75ff110 elementor-widget elementor-widget-image\" data-id=\"75ff110\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"272\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-services-1.jpg\" class=\"attachment-large size-large wp-image-8184\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-services-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-services-1-300x102.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/transaction-services-1-768x261.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-cd08c18 elementor-widget elementor-widget-text-editor\" data-id=\"cd08c18\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<\/p>\n<p>Let&#8217;s get down to business, we are not going to get too complicated, but the idea is to see what the interface looks like and do a test together! <\/p>\n<p>So, first what we need is:<\/p>\n<p><span style=\"background-color: transparent; font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight );\">1 &#8211; A table with whom we will make the transaction. For this example, I created a small test table. Check.  <\/span><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d8e59af elementor-widget elementor-widget-image\" data-id=\"d8e59af\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"457\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-ejemplo.jpg\" class=\"attachment-large size-large wp-image-8186\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-ejemplo.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-ejemplo-300x171.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-ejemplo-768x439.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-27331c3 elementor-widget elementor-widget-text-editor\" data-id=\"27331c3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>2 &#8211; Create the connection to this table. Check <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-029d4db elementor-widget elementor-widget-image\" data-id=\"029d4db\" 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=\"186\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conexion-tabla.jpg\" class=\"attachment-large size-large wp-image-8188\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conexion-tabla.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conexion-tabla-300x70.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conexion-tabla-768x179.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-a223ef4 elementor-widget elementor-widget-text-editor\" data-id=\"a223ef4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>3 &#8211; Create a new dossier and select our new table as data source.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1b24bd elementor-widget elementor-widget-image\" data-id=\"a1b24bd\" 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=\"314\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-como-origen-de-datos.jpg\" class=\"attachment-large size-large wp-image-8200\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-como-origen-de-datos.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-como-origen-de-datos-300x118.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/tabla-como-origen-de-datos-768x301.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-1ea8190 elementor-widget elementor-widget-text-editor\" data-id=\"1ea8190\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>4 &#8211; Make sure that it is imported correctly and select live connection.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71599f5 elementor-widget elementor-widget-image\" data-id=\"71599f5\" 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=\"454\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/acceso-live-connection.jpg\" class=\"attachment-large size-large wp-image-8202\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/acceso-live-connection.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/acceso-live-connection-300x170.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/acceso-live-connection-768x436.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-6d4aa35 elementor-widget elementor-widget-text-editor\" data-id=\"6d4aa35\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>5 &#8211; Create a new visualization of the <strong><em>modern grid type <\/em><\/strong>and add the fields we will work with.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa81380 elementor-widget elementor-widget-image\" data-id=\"fa81380\" 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=\"440\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cuadricula-moderna.jpg\" class=\"attachment-large size-large wp-image-8190\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cuadricula-moderna.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cuadricula-moderna-300x165.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cuadricula-moderna-768x422.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-b224f72 elementor-widget elementor-widget-text-editor\" data-id=\"b224f72\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>6 &#8211; This is where the magic begins. We will <em>set up transactions. Be careful. <\/em><strong><em>This option is available only in Workstation.<\/em><\/strong><em>.<br \/>If you try it from the web, the option will not appear.<br \/><\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cef1a57 elementor-widget elementor-widget-image\" data-id=\"cef1a57\" 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=\"251\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configurar-transacciones.jpg\" class=\"attachment-large size-large wp-image-8192\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configurar-transacciones.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configurar-transacciones-300x94.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configurar-transacciones-768x241.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-1db8ca7 elementor-widget elementor-widget-text-editor\" data-id=\"1db8ca7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>7 &#8211; And there we will see the options we have (update, delete or insert) and we will have to choose which table will be affected.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a67ce3 elementor-widget elementor-widget-image\" data-id=\"2a67ce3\" 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=\"795\" height=\"374\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/seleccionar-origen-datos.jpg\" class=\"attachment-large size-large wp-image-8194\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/seleccionar-origen-datos.jpg 795w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/seleccionar-origen-datos-300x141.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/seleccionar-origen-datos-768x361.jpg 768w\" sizes=\"(max-width: 795px) 100vw, 795px\" 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-324204e elementor-widget elementor-widget-text-editor\" data-id=\"324204e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>8 &#8211; For this example, we will choose to update the information by leaving the ID as the table key. To do this, we must define the <em>where <\/em>the query will use, by selecting the small icon next to the name. As you will see, there are also several options, but we will review this in the video.  <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5f6bbfd elementor-widget elementor-widget-image\" data-id=\"5f6bbfd\" 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=\"779\" height=\"678\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configuracion-de-transaccion.jpg\" class=\"attachment-large size-large wp-image-8204\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configuracion-de-transaccion.jpg 779w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configuracion-de-transaccion-300x261.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/configuracion-de-transaccion-768x668.jpg 768w\" sizes=\"(max-width: 779px) 100vw, 779px\" 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-ef790c6 elementor-widget elementor-widget-text-editor\" data-id=\"ef790c6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In the example you see above, what it will do is basically update the data for the ID. The query would look like this: <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5529e6 elementor-widget elementor-widget-image\" data-id=\"d5529e6\" 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=\"254\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/ejemplo-query.jpg\" class=\"attachment-large size-large wp-image-8206\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/ejemplo-query.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/ejemplo-query-300x95.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/ejemplo-query-768x244.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-8f38405 elementor-widget elementor-widget-text-editor\" data-id=\"8f38405\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>9 &#8211; Little more is left to test it. We will see how above the columns that we can edit a small pencil appears. We will try changing the city of Lucia Martinez (id 6) to Toledo.   <\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2888796 elementor-widget elementor-widget-image\" data-id=\"2888796\" 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=\"332\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambio-en-ejemplo-1.jpg\" class=\"attachment-large size-large wp-image-8208\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambio-en-ejemplo-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambio-en-ejemplo-1-300x125.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambio-en-ejemplo-1-768x319.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-16c19f9 elementor-widget elementor-widget-text-editor\" data-id=\"16c19f9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>10 &#8211; Finally, we go to the database to check that the information has been updated, and voil\u00e0:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bef2205 elementor-widget elementor-widget-image\" data-id=\"bef2205\" 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=\"663\" height=\"390\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/comprobacion-base-de-datos.jpg\" class=\"attachment-large size-large wp-image-8198\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/comprobacion-base-de-datos.jpg 663w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/comprobacion-base-de-datos-300x176.jpg 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" 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-dd7014a elementor-widget elementor-widget-heading\" data-id=\"dd7014a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Conclusions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e92c9a3 elementor-widget elementor-widget-text-editor\" data-id=\"e92c9a3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Congratulations, guys! We made it, and the possibilities are limited only by creativity. Next week we will analyze the options in detail with some video, but honestly it is a much simpler process than it was before, with the transaction reports and documents. I think this is a necessary, expected and very useful change because, above all, this is a <u>key <\/u>functionality and a competitive advantage that MicroStrategy has over the competition.   <\/p>\n<\/p>\n<p>I hope you found it useful, and I look forward to seeing you next week!<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-76ab15f elementor-widget elementor-widget-heading\" data-id=\"76ab15f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">References<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9c93574 elementor-widget elementor-widget-text-editor\" data-id=\"9c93574\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB47682-How-to-enable-the-Checkbox-Input-Control-style-in-a?language=en_US&amp;_gl=1*1r06ne3*_ga*MzY3MTE0NjMwLjE2Mzk5ODkwNjI.*_ga_0C9LVNZBZY*MTY5MDk2MDUyOC4yNi4xLjE2OTA5NjA2MjEuMC4wLjA\" target=\"_blank\" rel=\"noopener\">https:\/\/community.microstrategy.com\/s\/article\/KB47682-How-to-enable-the-Checkbox-Input-Control-style-in-a?language=en_US_gl=1*1r06ne3*_ga*MzY3MTE0NjMwLjE2Mzk5ODkwNjI.*_ga_0C9LVNZBZY*MTY5MDk2MDUyOC4yNi4xLjE2OTA5NjA2MjEuMC4wLjA<\/a>.<\/p>\n<\/p>\n<p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/Transaction-Homepage?language=en_US&amp;_gl=1*vc371l*_ga*MzY3MTE0NjMwLjE2Mzk5ODkwNjI.*_ga_0C9LVNZBZY*MTY5MDk2MDUyOC4yNi4xLjE2OTA5NjA1NjYuMC4wLjA\" target=\"_blank\" rel=\"noopener\">https:\/\/community.microstrategy.com\/s\/article\/Transaction-Homepage?language=en_US_gl=1*vc371l*_ga*MzY3MTE0NjMwLjE2Mzk5ODkwNjI.*_ga_0C9LVNZBZY*MTY5MDk2MDUyOC4yNi4xLjE2OTA5NjA1NjYuMC4wLjA<\/a>.<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=GUEkohw8gzM\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=GUEkohw8gzM<\/a><\/p>\n<p><a href=\"https:\/\/www2.microstrategy.com\/producthelp\/Current\/AdvancedReportingGuide\/WebHelp\/Lang_1033\/Content\/Creating_a_Transaction_Services_report.htm?Highlight=transaction%20serves\" target=\"_blank\" rel=\"noopener\">https:\/\/www2.microstrategy.com\/producthelp\/Current\/AdvancedReportingGuide\/WebHelp\/Lang_1033\/Content\/Creating_a_Transaction_Services_report.htm?Highlight=transaction%20serves<\/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-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\"> 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>Other Articles: Compartir en linkedin LinkedIn Compartir en facebook Facebook Compartir en twitter Twitter Compartir en whatsapp WhatsApp Hello everybody! Once again, here we come with a Transaction dossiers article to expand our universe of tips in our #BestInMicro space. Today we are going to test one of the new (old) functionalities: let&#8217;s see how [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":8217,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[72],"class_list":["post-8176","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\/8176","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=8176"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/8176\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/8217"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=8176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=8176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=8176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}