{"id":5157,"date":"2021-11-12T07:30:44","date_gmt":"2021-11-12T06:30:44","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=5157"},"modified":"2022-06-15T09:47:51","modified_gmt":"2022-06-15T08:47:51","slug":"microstrategy-pass-through-functions","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-pass-through-functions\/","title":{"rendered":"MicroStrategy Pass Through Functions"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5157\" class=\"elementor elementor-5157 elementor-5156\" 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\" data-e-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\" data-e-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-e-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=\"800\" height=\"208\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-pass-through-functions-1.jpg\" class=\"attachment-full size-full wp-image-5162\" alt=\"MicroStrategy Pass Through Functions\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-pass-through-functions-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-pass-through-functions-1-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-pass-through-functions-1-768x200.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\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\" data-e-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\" data-e-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-e-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-e-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\" data-e-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-e-type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">MicroStrategy Pass Through Functions<\/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-e-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\/11\/12\/\">\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>12\/11\/2021<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-e-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-e-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 );\">Good morning everyone, one more week here we are with our <i>#BestInMicro<\/i>! A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants.<\/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 );\">This week I bring a very useful functionality in MicroStrategy: <i>Pass-through<\/i> functionalities, which allow us to add by hand a query (or, rather, part of the query) to give a little more flexibility to the query we want to create or use. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aec05d8 elementor-widget elementor-widget-image\" data-id=\"aec05d8\" data-element_type=\"widget\" data-e-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=\"450\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/pass-through-functions-1.jpg\" class=\"attachment-large size-large wp-image-5178\" alt=\"Pass Through Functions\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/pass-through-functions-1.jpg 850w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/pass-through-functions-1-300x169.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/pass-through-functions-1-768x432.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-ed803bf elementor-widget elementor-widget-heading\" data-id=\"ed803bf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Introduction<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d34a690 elementor-widget elementor-widget-text-editor\" data-id=\"d34a690\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Also known as &#8220;Apply&#8221; function is functionality that MicroStrategy has, which allows us to manually write a query in the database. It has the feature that allows us to put variables or parameters in the query, so there is even a little more flexibility when using it.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb91b62 elementor-widget elementor-widget-heading\" data-id=\"cb91b62\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Where and what are they used for?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2761576 elementor-widget elementor-widget-text-editor\" data-id=\"2761576\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This depends on the function we are using (we explain each one below), but, for example, the <i>ApplyComparison<\/i>, appears mainly when defining filters, either integrated within a report or an indicator or as a filter object per se. On the other hand, <i>ApplySimple<\/i> is more related to defining indicators or attributes. Actually, it can be used anywhere where you need to do a manual injection of code to be used in a query. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20a986e elementor-widget elementor-widget-text-editor\" data-id=\"20a986e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>To simplify the explanation, this function is used to apply non-standard SQL expressions that MicroStrategy does not support or does not support.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f0d59c elementor-widget elementor-widget-image\" data-id=\"9f0d59c\" data-element_type=\"widget\" data-e-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=\"307\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/apply-comparison-1.jpg\" class=\"attachment-large size-large wp-image-5204\" alt=\"Apply Comparison\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/apply-comparison-1.jpg 937w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/apply-comparison-1-300x115.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/apply-comparison-1-768x295.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-12c7a76 elementor-widget elementor-widget-image\" data-id=\"12c7a76\" data-element_type=\"widget\" data-e-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=\"197\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/attention-1.jpg\" class=\"attachment-large size-large wp-image-5198\" alt=\"Attention\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/attention-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/attention-1-300x74.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/attention-1-768x189.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-fc08741 elementor-widget elementor-widget-heading\" data-id=\"fc08741\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Types of variables<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4b9fab elementor-widget elementor-widget-text-editor\" data-id=\"e4b9fab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Before going into the details of the types of <i>Apply Functions<\/i>, I will point out that these functions require certain variables to be passed as parameters. That is, we will create a SQL query and pass an attribute or value that will be dynamically embedded in our query. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-98be1e8 elementor-widget elementor-widget-text-editor\" data-id=\"98be1e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>For example, if we do the function <i>ApplySimple(&#8220;days_between(sysdate,<b>#0<\/b>)&#8221;,<b>Date@ID<\/b>)<\/i>, we will be getting the days that have passed between today and the date we are using in the date attribute&#8230; get it? We put between quotation marks the query that will be injected with its variables (which will be defined with a # and a number, which will define the order), and then, separated by commas, the fields that will fill these variables.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1a4c988 elementor-widget elementor-widget-text-editor\" data-id=\"1a4c988\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>And here comes an important trick, so stay tuned. It is possible to use prompts instead of attributes. But, for this, instead of using the expression <b>#n<\/b> we must use <b>#En<\/b>, indicating that we are inserting an element of the attribute. Let&#8217;s go to the example:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ad7239 elementor-widget elementor-widget-text-editor\" data-id=\"6ad7239\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Here I am using a function that uses the Month attribute and replaces it in the first parameter, while using a prompt for the second. A prompt returns an element, a value<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c43570 elementor-widget elementor-widget-image\" data-id=\"0c43570\" data-element_type=\"widget\" data-e-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=\"62\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-month-1.jpg\" class=\"attachment-large size-large wp-image-5196\" alt=\"Applycomparison Month\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-month-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-month-1-300x23.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-month-1-768x60.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-e5a5283 elementor-widget elementor-widget-text-editor\" data-id=\"e5a5283\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This query would end up being translated as follows:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f4d53d5 elementor-widget elementor-widget-image\" data-id=\"f4d53d5\" data-element_type=\"widget\" data-e-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=\"790\" height=\"33\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/query-month-1.jpg\" class=\"attachment-large size-large wp-image-5194\" alt=\"Query Month\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/query-month-1.jpg 790w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/query-month-1-300x13.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/query-month-1-768x32.jpg 768w\" sizes=\"(max-width: 790px) 100vw, 790px\" 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-87b5b63 elementor-widget elementor-widget-video\" data-id=\"87b5b63\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/RfkO7HU20xM&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-9ea6ffc elementor-widget elementor-widget-heading\" data-id=\"9ea6ffc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">What functions are available?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aca4af3 elementor-widget elementor-widget-text-editor\" data-id=\"aca4af3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Depending on the situation, we have different types of <i>Apply functions<\/i>. Here I explain which ones exist, how they are used and what they are for. To see examples of the structure and go into more detail, I recommend that you take a look at this <a style=\"background-color: #ffffff; font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\" href=\"https:\/\/www2.microstrategy.com\/producthelp\/2019\/MSTRWeb\/FunctionsRef\/Content\/FuncRef\/Apply__Pass_Through__functions.htm\" target=\"_blank\" rel=\"noopener\">technical note from MicroStrategy.<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a58062d elementor-widget elementor-widget-text-editor\" data-id=\"a58062d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>ApplySimple<\/b><\/p><p> It is used to create different MicroStrategy objects. It is used to insert <u>non-addable<\/u> values (for those there is the <i>ApplyAgg<\/i>) and to use native functions of the SQL engine we are querying. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6345b89 elementor-widget elementor-widget-image\" data-id=\"6345b89\" data-element_type=\"widget\" data-e-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=\"40\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applysimple-greatest-1.jpg\" class=\"attachment-large size-large wp-image-5192\" alt=\"Applysimple Greatest\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applysimple-greatest-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applysimple-greatest-1-300x15.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applysimple-greatest-1-768x38.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-14ecf67 elementor-widget elementor-widget-text-editor\" data-id=\"14ecf67\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>For example, here we see how to create an indicator based on the <i>greatest<\/i> formula and pass it to different parameters.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a6dd3a5 elementor-widget elementor-widget-text-editor\" data-id=\"a6dd3a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>ApplyComparison<\/b><\/p><p>This function is mainly used in advanced filters. Allows us to handwrite the condition that will appear inside the <i>where<\/i>. It is important to have the advanced filters enabled by going to <i>Tools &gt; My Preferences &gt; Editors &gt; Filters &gt; Show advanced qualifications.<\/i><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-47d2547 elementor-widget elementor-widget-image\" data-id=\"47d2547\" data-element_type=\"widget\" data-e-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=\"397\" height=\"214\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/filtering-options-1.jpg\" class=\"attachment-large size-large wp-image-5202\" alt=\"Filtering Options\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/filtering-options-1.jpg 397w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/filtering-options-1-300x162.jpg 300w\" sizes=\"(max-width: 397px) 100vw, 397px\" 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-4ecfc7e elementor-widget elementor-widget-text-editor\" data-id=\"4ecfc7e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In this example, we use the <i>ApplyComparison<\/i> to add the filter that the description of the <i>customer city<\/i> attribute is the same as <i>call center<\/i><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e218b62 elementor-widget elementor-widget-image\" data-id=\"e218b62\" data-element_type=\"widget\" data-e-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=\"37\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-customer-city-1.jpg\" class=\"attachment-large size-large wp-image-5190\" alt=\"Applycomparison Customer City\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-customer-city-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-customer-city-1-300x14.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-customer-city-1-768x36.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-d67cfef elementor-widget elementor-widget-image\" data-id=\"d67cfef\" data-element_type=\"widget\" data-e-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=\"529\" height=\"322\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-example-1.jpg\" class=\"attachment-large size-large wp-image-5200\" alt=\"Applycomparison Example\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-example-1.jpg 529w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applycomparison-example-1-300x183.jpg 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" 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-51073e7 elementor-widget elementor-widget-text-editor\" data-id=\"51073e7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>ApplyOlap<\/b><\/p><p>This is used when analytical processing functions are required. Recall that we refer to performing sorting, aggregation, and dynamic operations.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68f7a7e elementor-widget elementor-widget-image\" data-id=\"68f7a7e\" data-element_type=\"widget\" data-e-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=\"64\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyolap-1.jpg\" class=\"attachment-large size-large wp-image-5188\" alt=\"Applyolap\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyolap-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyolap-1-300x24.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyolap-1-768x61.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-7a90614 elementor-widget elementor-widget-text-editor\" data-id=\"7a90614\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>ApplyLogic<\/b><\/p><p>This function is used in filters when logical operators (e.g. AND, OR, and NOT) need to be implemented. It is characterized by a Boolean response, i.e. true or false. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-76babe2 elementor-widget elementor-widget-image\" data-id=\"76babe2\" data-element_type=\"widget\" data-e-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=\"43\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applylogic-1.jpg\" class=\"attachment-large size-large wp-image-5186\" alt=\"Applylogic\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applylogic-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applylogic-1-300x16.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applylogic-1-768x41.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-e4f8ed6 elementor-widget elementor-widget-text-editor\" data-id=\"e4f8ed6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>ApplyAgg<\/b><\/p><p>These functions are used when aggregate functions (e.g. Sum) can be used.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0992c6f elementor-widget elementor-widget-image\" data-id=\"0992c6f\" data-element_type=\"widget\" data-e-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=\"46\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyagg-1.jpg\" class=\"attachment-large size-large wp-image-5184\" alt=\"Applyagg\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyagg-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyagg-1-300x17.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/applyagg-1-768x44.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-85974cb elementor-widget elementor-widget-heading\" data-id=\"85974cb\" data-element_type=\"widget\" data-e-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-b9c2140 elementor-widget elementor-widget-text-editor\" data-id=\"b9c2140\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>These functionalities are very useful in different scenarios, especially when you have some complex data to extract through MicroStrategy&#8217;s SQL engine, or when you simply have limitations when creating objects. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79dbc97 elementor-widget elementor-widget-text-editor\" data-id=\"79dbc97\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>It is important to consider the language in which you write, as mentioned above. It is not the same to make a query that will be executed in an Oracle than in a Teradata, for example, so it is necessary to take special care in these aspects and to analyze well how the query is generated.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fd23acc elementor-widget elementor-widget-text-editor\" data-id=\"fd23acc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Anyway, I hope you found this article useful and I look forward to seeing you next week for a new article!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae045c8 elementor-widget elementor-widget-heading\" data-id=\"ae045c8\" data-element_type=\"widget\" data-e-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-06807ee elementor-widget elementor-widget-text-editor\" data-id=\"06807ee\" data-element_type=\"widget\" data-e-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.4\/FunctionsRef\/Content\/FuncRef\/Apply__Pass_Through__functions.htm\" target=\"_blank\" rel=\"noopener\">Apply (Pass-Through) functions (microstrategy.com)<\/a><\/p><p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/MicroStrategy-Passthrough-Filters-Online-Training-Video-by-MicroRooster?language=en_US\" target=\"_blank\" rel=\"noopener\">Article Detail (microstrategy.com)<\/a><\/p><p><a href=\"https:\/\/www2.microstrategy.com\/producthelp\/Current\/MDXCubeReporting\/WebHelp\/Lang_1033\/Content\/Using_Prompts_and_ApplySimple_Statements.htm\" target=\"_blank\" rel=\"noopener\">Using Prompts and ApplySimple Statements (microstrategy.com)<\/a><\/p><p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB3905-How-to-use-pass-through-expression-ApplySimple-in?language=en_US\" target=\"_blank\" rel=\"noopener\">KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine<\/a><\/p><p><a href=\"https:\/\/www2.microstrategy.com\/producthelp\/Current\/ReportDesigner\/WebHelp\/Lang_1033\/Content\/ApplySimple.htm\" target=\"_blank\" rel=\"noopener\">Ap<\/a><a style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight ); background-color: #ffffff;\" href=\"https:\/\/www2.microstrategy.com\/producthelp\/Current\/ReportDesigner\/WebHelp\/Lang_1033\/Content\/ApplySimple.htm\" target=\"_blank\" rel=\"noopener\">plySimple (microstrategy.com)<\/a><\/p><p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB6178-How-to-use-pass-through-expression-ApplyComparison-in?language=en_US\" target=\"_blank\" rel=\"noopener\">KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine<\/a><\/p><p><a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB20022-How-to-use-the-ApplyComparison-function-to-bypass-the-SQL?language=en_US\" target=\"_blank\" rel=\"noopener\">KB20022: How to use the ApplyComparison function to bypass the SQL engine in MicroStrategy<\/a><\/p><p><a href=\"https:\/\/www.omarvidaure.com\/post\/aapplysimple-vs-applycomparison-microstrategy\" target=\"_blank\" rel=\"noopener\">ApplySimple vs ApplyComparison (MicroStrategy) (omarvidaure.com)<\/a><\/p><p><a href=\"https:\/\/www.toolbox.com\/tech\/question\/creating-attribute-with-applysimple-042709\/\" target=\"_blank\" rel=\"noopener\">Creating attribute with applysimple | Toolbox Tech<\/a><\/p><p><a href=\"https:\/\/stackoverflow.com\/questions\/66282604\/microstrategy-apply-simple-with-certain-text\" target=\"_blank\" rel=\"noopener\">case &#8211; Microstrategy Apply Simple with Certain Text &#8211; Stack Overflow<\/a><\/p><p> <\/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-e-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-e-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 a very useful functionality in MicroStrategy: Pass-through functionalities, which allow us to add by hand a query (or, rather, part of the query) to give a little more flexibility to the query we want to create or use. <\/p>\n","protected":false},"author":2,"featured_media":5162,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[71],"class_list":["post-5157","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\/5157","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=5157"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/5157\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/5162"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=5157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=5157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=5157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}