{"id":3804,"date":"2020-10-30T10:36:40","date_gmt":"2020-10-30T09:36:40","guid":{"rendered":"https:\/\/bestdatasolutions.es\/microstrategy-metadata-queries\/"},"modified":"2023-06-22T14:47:03","modified_gmt":"2023-06-22T13:47:03","slug":"microstrategy-metadata-queries","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-metadata-queries\/","title":{"rendered":"MicroStrategy Metadata Queries"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3804\" class=\"elementor elementor-3804 elementor-1019\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0a1032c elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"0a1032c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-193ec6b\" data-id=\"193ec6b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4ec768b elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"4ec768b\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1920\" height=\"500\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-metadata-queries-main.jpg\" class=\"attachment-full size-full wp-image-1097\" alt=\"MicroStrategy Metadata Queries\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-metadata-queries-main.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-metadata-queries-main-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-metadata-queries-main-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-metadata-queries-main-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/microstrategy-metadata-queries-main-1536x400.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-36745c18 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36745c18\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-eca8c7e\" data-id=\"eca8c7e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4fea62f elementor-author-box--layout-image-left elementor-author-box--align-left elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--name-yes elementor-author-box--biography-yes elementor-author-box--link-no elementor-widget elementor-widget-author-box\" data-id=\"4fea62f\" data-element_type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/es.linkedin.com\/in\/joacoatt\" target=\"_blank\" class=\"elementor-author-box__avatar\" rel=\"noopener\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/joaquin-attanasio-1.jpg\" alt=\"Picture of Joaquin Attanasio\" loading=\"lazy\" title=\"\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/es.linkedin.com\/in\/joacoatt\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tJoaquin Attanasio\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\tBusiness Intelligence Consultant | Microstrategy Expert | Data Specialist\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03967a6 elementor-widget elementor-widget-heading\" data-id=\"03967a6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-large\">Other Articles:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-1e8c404\" data-id=\"1e8c404\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-aedd84f elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"aedd84f\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">MicroStrategy Metadata Queries<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe7fcc4 elementor-widget elementor-widget-post-info\" data-id=\"fe7fcc4\" data-element_type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-869d2fb elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/bestdatasolutions.es\/en\/2020\/10\/30\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-calendar\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M12 192h424c6.6 0 12 5.4 12 12v260c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V204c0-6.6 5.4-12 12-12zm436-44v-36c0-26.5-21.5-48-48-48h-48V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H160V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H48C21.5 64 0 85.5 0 112v36c0 6.6 5.4 12 12 12h424c6.6 0 12-5.4 12-12z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>30\/10\/2020<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99a4974 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=\"99a4974\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a09409 elementor-widget elementor-widget-text-editor\" data-id=\"0a09409\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>New week, new article: welcome back to #BestInMicro! This is a space where I will be writing about different topics related to MicroStrategy, its use, best practices, and functionalities to get the most out of the tool.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12fe4bc elementor-widget elementor-widget-image\" data-id=\"12fe4bc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"378\" height=\"226\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-1.png\" class=\"attachment-large size-large wp-image-1053\" alt=\"MicroStrategy-Metadata-Queries-1\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-1.png 378w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-1-300x179.png 300w\" sizes=\"(max-width: 378px) 100vw, 378px\" 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-39a4b1b elementor-widget elementor-widget-text-editor\" data-id=\"39a4b1b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Today I bring you an essential article for any administrator. Today I will be talking about MicroStrategy Metadata and some queries that are very useful when administering the tool. Let&#8217;s get started! And as every week, first things first&#8230;<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5e07a36 elementor-widget elementor-widget-heading\" data-id=\"5e07a36\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">What is MicroStrategy Metadata?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8473776 elementor-widget elementor-widget-text-editor\" data-id=\"8473776\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The Metadata is where all the MicroStrategy definition is stored. It is a database where the whole &#8220;skeleton&#8221; of the tool is located. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. <\/p>\n<p>Going to the basics, below is the basic outline of the MicroStrategy architecture:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f3fe55 elementor-widget elementor-widget-image\" data-id=\"9f3fe55\" 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=\"397\" height=\"379\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-2.gif\" class=\"attachment-large size-large wp-image-1056\" alt=\"MicroStrategy-Metadata-Queries-2\" 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-3c4c25f elementor-widget elementor-widget-text-editor\" data-id=\"3c4c25f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The MicroStrategy Metadata stores the information of all the objects we have in our environment. By connecting to Metadata, the Intelligence server is already able to show us the entire structure of our environment. This is why, if you remember my article about <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-scanmd\/\" target=\"_blank\" rel=\"noopener\">ScanMD and its risks,<\/a> you will now understand a little more why it is so important to handle Metadata with extreme caution.<\/p>\n<p>Many of you may be familiar with tools such as Enterprise Manager or Platform analytics. These are projects that are used to monitor the MicroStrategy environment. If we think together for a minute, they allow us to put together reports that provide information of two types: What objects exist and their statistics&#8230; and where do you think you get the information about the objects? You got it right, they are queries against Metadata! So, if we already have these projects to extract information, you may wonder&#8230;<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b4cf98c elementor-widget elementor-widget-heading\" data-id=\"b4cf98c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">In which situations is it necessary to do a direct Query against the Metadata?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4337a17 elementor-widget elementor-widget-text-editor\" data-id=\"4337a17\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Although these are useful tools and make this task much easier, the need to consult the Metadata directly is a relatively frequent scenario. There are times when queries require very exact precision, or even to consult some tables that do not exist in the model of the projects mentioned above.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a47deae elementor-widget elementor-widget-image\" data-id=\"a47deae\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"567\" height=\"234\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-3.png\" class=\"attachment-large size-large wp-image-1059\" alt=\"MicroStrategy-Metadata-Queries-3\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-3.png 567w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-3-300x124.png 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" 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-7a78e20 elementor-widget elementor-widget-heading\" data-id=\"7a78e20\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Metadata Structure<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd6664e elementor-widget elementor-widget-text-editor\" data-id=\"cd6664e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As we said before, Metadata is a database, and, therefore, it is made up of tables. Although you can consult in detail the Metadata tables, here below I explain the most common ones.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0cd4e8b elementor-widget elementor-widget-text-editor\" data-id=\"0cd4e8b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li><b>DSSMDOBJDEPN:<\/b> This table stores the relationship between objects. For example, in this table, we will find if a folder is inside another one, if a user belongs to a group or if a fact is used in an indicator.<\/li>\n<li><b>DSSMDOBJINFO: <\/b>This table details the objects, their type, their IDs, their names, and all the relevant information of each one. This is probably the table you consult the most.<\/li>\n<li><b>DSSMDUSRACCT:<\/b> here are the users and the type of authentication they use.<\/li>\n<li><b>DSSMDOBJSECU:<\/b> Contains the security of each object.<\/li>\n<\/ul>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fa42e3 elementor-widget elementor-widget-heading\" data-id=\"3fa42e3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Using UniqueIdentifier<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4209aea elementor-widget elementor-widget-text-editor\" data-id=\"4209aea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Although here we are talking exclusively about the Metadata tables, in many situations you will want to join with the statistics tables, precisely to know from which objects the statistics are extracted. In these cases, you will notice that the ID of the objects between the different databases are different, and have different formatting. For these cases, for example <b>in SQLServer<\/b>(depending on the database used will vary), the functions fn_CharToUniqueidentifier or fn_UniqueidentifierToCharMSTR are used. These functions, as the name indicates, &#8220;caste&#8221; the object IDs by changing their structure to allow us to make the join. Below is the code of the functions. As you can see, it is basically a set of subStrings ordered or separated by dashes.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-406c70d elementor-widget elementor-widget-text-editor\" data-id=\"406c70d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>CREATE FUNCTION dbo.fn_UniqueidentifierToCharMSTR(@charid CHAR(36))<br \/>RETURNS CHAR(32)<br \/>AS<br \/>BEGIN<br \/>DECLARE @tpid VARCHAR(32)<br \/>SET @tpid = SUBSTRING(@charid, 1, 8)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 15, 4)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 10, 4)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 27, 2)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 25, 2)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 22, 2)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 20, 2)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 35, 2)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 33, 2)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 31, 2)<br \/>SET @tpid = @tpid + SUBSTRING(@charid, 29, 2)<br \/>RETURN @tpid<br \/>END<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c1bba9c elementor-widget elementor-widget-text-editor\" data-id=\"c1bba9c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>CREATE FUNCTION dbo.fn_CharToUniqueidentifier(@charid CHAR(32))<br \/>RETURNS UNIQUEIDENTIFIER<br \/>AS<br \/>BEGIN<br \/> DECLARE @tpid VARCHAR(36)<br \/> DECLARE @uid UNIQUEIDENTIFIER<br \/> SET @tpid = SUBSTRING(@charid, 1, 8) + &#8216;-&#8216;<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 13, 4) + &#8216;-&#8216;<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 9, 4) + &#8216;-&#8216;<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 23, 2)<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 21, 2) + &#8216;-&#8216;<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 19, 2)<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 17, 2)<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 31, 2)<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 29, 2)<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 27, 2)<br \/> SET @tpid = @tpid + SUBSTRING(@charid, 25, 2)<br \/> SET @uid = CAST(@tpid AS UNIQUEIDENTIFIER)<br \/> RETURN @uid<br \/>END<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08c48dc elementor-widget elementor-widget-text-editor\" data-id=\"08c48dc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u00a1Y Ahora s\u00ed, con estas funciones, podr\u00e1n hacer queries entre la Bases de estad\u00edsticas y la Metadata! Por ejemplo, a continuaci\u00f3n, convertimos el Project id de la Metadata en el GUID de la base de estad\u00edsticas. Do you dare to do the reverse?<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef00369 elementor-widget elementor-widget-text-editor\" data-id=\"ef00369\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>select<\/b> MD.PROJECT_ID,<br \/> EM.IS_PROJ_GUID,<br \/> EM.IS_PROJ_NAME <br \/><b>from<\/b> <i>METADATA<\/i>.dbo.Dssmdobjinfo MD, <i><u>Statistics<\/u><\/i>.<i>stats<\/i>.IS_proj EM<br \/><b>where<\/b> <i>METADATA<\/i>.dbo.fn_UniqueidentifierToCharMSTR (MD.PROJECT_ID) = EM.IS_PROJ_GUID;<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ab3834 elementor-widget elementor-widget-image\" data-id=\"3ab3834\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"567\" height=\"51\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-4.png\" class=\"attachment-large size-large wp-image-1062\" alt=\"MicroStrategy-Metadata-Queries-4\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-4.png 567w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-4-300x27.png 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" 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-61b77e9 elementor-widget elementor-widget-heading\" data-id=\"61b77e9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Top Metadata Queries<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0320bce elementor-widget elementor-widget-text-editor\" data-id=\"0320bce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>As MicroStrategy releases progress, the Metadata is updated, and new tables appear or are modified, so if one of the following queries does not work, perhaps it is a matter of changing the name of a field or a table (a good exercise to get familiar with query creation!) <\/p>\n<p>Here is a list of the most useful queries or the ones I use most frequently:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3facc75 elementor-widget elementor-widget-text-editor\" data-id=\"3facc75\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li><b><u>Object types<\/u><\/b>: this is a view that I recommend you create and save. It is a query that makes it easier to understand which<a href=\"https:\/\/community.microstrategy.com\/s\/article\/KB16048-List-of-all-object-types-and-object-descriptions-in?language=en_US\" target=\"_blank\" rel=\"noopener\"> objects each object type<\/a> refers to since no lookup tells us this. <\/li>\n<\/ul>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc14b72 elementor-widget elementor-widget-text-editor\" data-id=\"fc14b72\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b><span lang=\"EN-US\">select<\/span><\/b><span lang=\"EN-US\">o.project_id,<br \/> o.OBJECT_TYPE type_code<\/span><span lang=\"EN-US\">,<br \/><\/span> <b><span lang=\"EN-US\"> case<\/span><\/b><span lang=\"EN-US\">o.object_type <br \/><\/span>  <b><span lang=\"EN-US\"> when<\/span><\/b> <span lang=\"EN-US\">1<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;filter&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">2<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;template&#8217; <br \/><\/span> <span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">3<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;report&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">4<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;metric&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">6<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;autostyle&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">8<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;folder&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">10<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;prompt&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">11<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;function&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">12<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;attribute&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">13<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;fact&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">14<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;hierarchy&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">15<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;table&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">21<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;attribute ID&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">22<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;schema&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">24<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;warehouse catalog&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">25<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;warehouse catalog definition&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">26<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;table column&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">28<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;property sets&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">34<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;users\/groups&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">39<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;search&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">42<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;package&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">47<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;consolidation&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">52<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;link&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">53<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;table&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">56<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;drill map&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">when<\/span><\/b> <span lang=\"EN-US\">58<\/span> <b><span lang=\"EN-US\">then<\/span><\/b> <span lang=\"EN-US\">&#8216;security filter&#8217;<br \/><\/span><span lang=\"EN-US\">                <\/span><b><span lang=\"EN-US\">else<\/span><\/b> <span lang=\"EN-US\">&#8216;Other&#8217;<\/span><\/p>\n<p> <b><span lang=\"EN-US\"> end<\/span><\/b> <b><span lang=\"EN-US\">AS<\/span><\/b> <span lang=\"EN-US\"><b>type<\/b><\/span>, <br \/> o.object_name,<br \/> o.object_id<br \/><b><span lang=\"EN-US\">from<\/span><\/b><span lang=\"EN-US\">dssmdobjinfo o<br \/><\/span><b><span lang=\"EN-US\">order<\/span><\/b> <b><span lang=\"EN-US\">by<\/span><\/b> <b><span lang=\"EN-US\">type<\/span><\/b><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85aaf94 elementor-widget elementor-widget-text-editor\" data-id=\"85aaf94\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li><b><u>Description of the ACL<\/u><\/b>: You will see that if you want to extract the security of the different objects, you will see that some codes describe the ACL of each object. This is why the following query is useful. This gives us a more descriptive code of what permissions each object has. As you might imagine, the custom indicates, using the initials, the permissions you have based on the following:<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43a6011 elementor-widget elementor-widget-image\" data-id=\"43a6011\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"268\" height=\"188\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/MicroStrategy-Metadata-Queries-5.png\" class=\"attachment-large size-large wp-image-1065\" alt=\"MicroStrategy-Metadata-Queries-5\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40de440 elementor-widget elementor-widget-text-editor\" data-id=\"40de440\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Therefore, if it says Custom E1U0C0D0W0R0 it means that you will be able to Execute, but not the rest. Finally, the ?0BX indicates whether it is inherited permission by default (B0) or manually assigned (B1).<\/p>\n<p>To understand a little more, <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-security\/\">don&#8217;t forget to check out the MicroStrategy security article!<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed067c8 elementor-widget elementor-widget-text-editor\" data-id=\"ed067c8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>select DISTINCT RIGHTS, CASE RIGHTS <br \/>WHEN 1 THEN &#8221; &#8212; b00000001 <br \/>WHEN 5 THEN &#8216;Custom E0U0C0D0W0R1?1B1&#8217; &#8212; b00000011 <br \/>WHEN 13 THEN &#8221; &#8212; b00001101 <br \/>WHEN 128 THEN &#8216;Custom E1U0C0D0W0R0?0B0&#8217; &#8212; b10000000 <br \/>WHEN 132 THEN &#8221; &#8212; b10000100 <br \/>WHEN 133 THEN &#8221; &#8212; b10000101 <br \/>WHEN 198 THEN &#8216;Custom E1U1C0D0W0R1?1B0&#8217; &#8212; b11000110 <br \/>WHEN 199 THEN &#8216;View&#8217; &#8212; b11000111 <br \/>WHEN 207 THEN &#8216;Custom E1U1C0D0W1R1?1B1&#8217; &#8212; b11001111 <br \/>WHEN 223 THEN &#8216;Modify&#8217; &#8212; b11011111 <br \/>WHEN 239 THEN &#8221; &#8212; b11101111 <br \/>WHEN 251 THEN &#8221; &#8212; b11111011 <br \/>WHEN 255 THEN &#8216;Full Control&#8217; &#8212; b11111111 <br \/>WHEN 268435504 THEN &#8216;Custom E1U1C0D0W1R1?1B1&#8217; &#8212; B010000000000000000000000110000 ?? 0==grant <br \/>WHEN 268435505 THEN &#8216;Custom E1U1C0D0W1R1?1B0&#8217; &#8212; B010000000000000000000000110001 ?? 0==default <br \/>WHEN 268435512 THEN &#8216;Custom E1U1C0D0W0R1?1B1&#8217; &#8212; B010000000000000000000000111000 <br \/>WHEN 268435513 THEN &#8216;Custom E1U1C0D0W0R1?1B0&#8217; &#8212; B010000000000000000000000111001 <br \/>WHEN 268435579 THEN &#8216;Custom E1U0C0D0W0R1?0B0&#8217; &#8212; B010000000000000000000001111011 <br \/>WHEN 268435583 THEN &#8216;Custom E1U0C0D0W0R0?0B0&#8217; &#8212; B010000000000000000000001111111 <br \/>WHEN 268435711 THEN &#8216;Denied All&#8217; &#8212; B010000000000000000000011111111 <br \/>WHEN 536870913 THEN &#8216;Child Custom E0U0C0D0W0R0?0B1&#8217; &#8212; B100000000000000000000000000001 <br \/>WHEN 536870917 THEN &#8216;Child Custom E0U0C0D0W0R1?0B1&#8217; &#8212; B100000000000000000000000000101 <br \/>WHEN 536871110 THEN &#8216;Child Custom E1U1C0D0W0R1?1B0&#8217; &#8212; B100000000000000000000011000110 <br \/>WHEN 536871111 THEN &#8216;Child View&#8217; &#8212; B100000000000000000000011000111 <br \/>WHEN 536871119 THEN &#8216;Child Custom E1U1C0D0W1R1?1B1&#8217; &#8212; B100000000000000000000011001111 <br \/>WHEN 536871135 THEN &#8216;Child Modify&#8217; &#8212; B100000000000000000000011011111 <br \/>WHEN 536871167 THEN &#8216;Child Full Control&#8217; &#8212; B100000000000000000000011111111 <br \/>WHEN 805306369 THEN &#8216;Child Custom E1U1C1D1W1R1?1B0&#8217; &#8212; B110000000000000000000000000001 <br \/>WHEN 805306400 THEN &#8216;Child Custom E1U1C0D1W1R1?1B1&#8217; &#8212; B110000000000000000000000100000 <br \/>WHEN 805306416 THEN &#8216;Child View&#8217; &#8212; B110000000000000000000000110000 <br \/>WHEN 805306424 THEN &#8216;Child Custom E1U1C0D0W0R1?1B1&#8217; &#8212; B110000000000000000000000111000 <br \/>WHEN 805306425 THEN &#8216;Child Custom E1U1C0D0W0R1?1B0&#8217; &#8212; B110000000000000000000000111001 <br \/>WHEN 805306623 THEN &#8216;Child Denied All&#8217; &#8212; B110000000000000000000011111111 <br \/>WHEN 1610612736 THEN &#8221; &#8212; B1100000000000000000000000000000 <br \/>ELSE &#8216;Unknown&#8217; <br \/>END DESCRIPTION <br \/>from dssmdobjsecu<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbbf7d6 elementor-widget elementor-widget-text-editor\" data-id=\"cbbf7d6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li><u><b>List all objects: <\/b><\/u>This query goes in combination with the one we saw in the first step. Based on the first one, where we saw that each object has its own type. With this query we will be able to extract all the objects we have in a project:<\/li>\n<\/ul>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f0330b elementor-widget elementor-widget-text-editor\" data-id=\"2f0330b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span lang=\"EN-US\">WITH Parent AS (SELECT OBJECT_ID, PROJECT_ID AS project_id, PARENT_ID AS Parent_ID, OBJECT_TYPE AS object_type, CAST(OBJECT_NAME AS varchar(MAX)) AS OBJECT_NAME<\/span><\/p>\n<p><span lang=\"EN-US\"> FROM dbo.DSSMDOBJINFO<\/span><\/p>\n<p><span lang=\"EN-US\"> WHERE (PARENT_ID = \u201800000000-0000-0000-0000-000000000000\u2019) and object_name =\u2019MicroStrategy Tutorial\u2019<\/span><\/p>\n<p><span lang=\"EN-US\"> UNION all<\/span><\/p>\n<p><span lang=\"EN-US\"> SELECT TH.OBJECT_ID, TH.PROJECT_ID, TH.PARENT_ID, TH.OBJECT_TYPE, CONVERT(varchar(MAX), Parent_2.OBJECT_NAME + \u2018\/\u2019 + TH.OBJECT_NAME) AS Path<\/span><\/p>\n<p><span lang=\"EN-US\"> FROM dbo.DSSMDOBJINFO AS TH INNER JOIN<\/span><\/p>\n<p><span lang=\"EN-US\"> Parent AS Parent_2 ON Parent_2.OBJECT_ID = TH.PARENT_ID AND Parent_2.project_id = TH.PROJECT_ID)<\/span><\/p>\n<p><span lang=\"EN-US\">SELECT distinct d.OBJECT_NAME AS Project_name, b.OBJECT_NAME, b.OBJECT_TYPE,<\/span><\/p>\n<p><span lang=\"EN-US\"> CASE WHEN b.object_type = &#8211; 1 THEN \u2018Unknown\u2019 WHEN b.object_type = 0 THEN \u2018Reserved\u2019 WHEN b.object_type = 1 THEN \u2018Filter\u2019 WHEN b.object_type = 2 THEN \u2018Template\u2019 WHEN b.object_type = 3 THEN \u2018ReportDefinition\u2019<\/span><\/p>\n<pre><span lang=\"EN-US\">       WHEN b.object_type = 4 THEN \u2018Metric\u2019 WHEN b.object_type = 5 THEN \u2018Unused\u2019 WHEN b.object_type = 6 THEN \u2018Autostyles\u2019 WHEN b.object_type = 7 THEN \u2018AggMetric\u2019 WHEN b.object_type = 8 THEN \u2018Folder\u2019 WHEN<br\/><\/span><span lang=\"EN-US\">       b.object_type = 9 THEN \u2018Unused\u2019 WHEN b.object_type = 10 THEN \u2018Prompt\u2019 WHEN b.object_type = 11 THEN \u2018Function\u2019 WHEN b.object_type = 12 THEN \u2018Attribute\u2019 WHEN b.object_type = 13 THEN \u2018Fact\u2019 WHEN b.object_type<br\/><\/span><span lang=\"EN-US\">       = 14 THEN \u2018Dimension\u2019 WHEN b.object_type = 15 THEN \u2018Table\u2019 WHEN b.object_type = 16 THEN \u2018Unused\u2019 WHEN b.object_type = 17 THEN \u2018FactGroup\u2019 WHEN b.object_type = 18 THEN \u2018Shortcut\u2019 WHEN b.object_type<br\/><\/span><span lang=\"EN-US\">       = 19 THEN \u2018Resolution\u2019 WHEN b.object_type = 20 THEN \u2018Unused\u2019 WHEN b.object_type = 21 THEN \u2018AttributeForm\u2019 WHEN b.object_type = 22 THEN \u2018Schema\u2019 WHEN b.object_type = 23 THEN \u2018FindObject\u2019 WHEN b.object_type<br\/><\/span><span lang=\"EN-US\">       = 24 THEN \u2018Catalog\u2019 WHEN b.object_type = 25 THEN \u2018CatalogDefn\u2019 WHEN b.object_type = 26 THEN \u2018Column\u2019 WHEN b.object_type = 27 THEN \u2018PropertyGroup\u2019 WHEN b.object_type = 28 THEN \u2018PropertySet\u2019 WHEN<br\/><\/span><span lang=\"EN-US\">       b.object_type = 29 THEN \u2018DBRole\u2019 WHEN b.object_type = 30 THEN \u2018DBLogin\u2019 WHEN b.object_type = 31 THEN \u2018DBConnection\u2019 WHEN b.object_type = 32 THEN \u2018Project\u2019 WHEN b.object_type = 33 THEN \u2018ServerDef\u2019<br\/><\/span><span lang=\"EN-US\">       WHEN b.object_type = 34 THEN \u2018User\u2019 WHEN b.object_type = 35 THEN \u2018Unused\u2019 WHEN b.object_type = 36 THEN \u2018Configuration\u2019 WHEN b.object_type = 37 THEN \u2018Request\u2019 WHEN b.object_type = 38 THEN \u2018Unused\u2019<br\/><\/span><span lang=\"EN-US\">       WHEN b.object_type = 39 THEN \u2018Search\u2019 WHEN b.object_type = 40 THEN \u2018SearchFolder\u2019 WHEN b.object_type = 41 THEN \u2018Unused\u2019 WHEN b.object_type = 42 THEN \u2018FunctionPackageDefinition\u2019 WHEN b.object_type<br\/><\/span><span lang=\"EN-US\">       = 43 THEN \u2018Role\u2019 WHEN b.object_type = 44 THEN \u2018SecurityRole\u2019 WHEN b.object_type = 45 THEN \u2018InBox\u2019 WHEN b.object_type = 46 THEN \u2018InBoxMsg\u2019 WHEN b.object_type = 47 THEN \u2018Consolidation\u2019 WHEN b.object_type<br\/><\/span><span lang=\"EN-US\">       = 48 THEN \u2018ConsolidationElement\u2019 WHEN b.object_type = 49 THEN \u2018ScheduleEvent\u2019 WHEN b.object_type = 50 THEN \u2018ScheduleObject\u2019 WHEN b.object_type = 51 THEN \u2018ScheduleTrigger\u2019 WHEN b.object_type = 52<br\/><\/span><span lang=\"EN-US\">       THEN \u2018Link\u2019 WHEN b.object_type = 53 THEN \u2018DBTable\u2019 WHEN b.object_type = 54 THEN \u2018TableSource\u2019 WHEN b.object_type = 55 THEN \u2018DocumentDefinition\u2019 WHEN b.object_type = 56 THEN \u2018DrillMap\u2019 WHEN b.object_type<br\/><\/span><span lang=\"EN-US\">       = 57 THEN \u2018DBMS\u2019 WHEN b.object_type = 58 THEN \u2018MDSecurityFilter\u2019 WHEN b.object_type = 59 THEN \u2018PromptAnswer\u2019 WHEN b.object_type = 60 THEN \u2018PromptAnswers\u2019 WHEN b.object_type = 61 THEN \u2018GraphStyle\u2019<br\/><\/span><span lang=\"EN-US\">       WHEN b.object_type = 62 THEN \u2018ChangeJournalSearch\u2019 WHEN b.object_type = 63 THEN \u2018Blob\u2019 WHEN b.object_type = 64 THEN \u2018DashboardTemplate\u2019 WHEN b.object_type = 65 THEN \u2018Flag\u2019 WHEN b.object_type<br\/><\/span><span lang=\"EN-US\">       = 66 THEN \u2018ChangeJournal\u2019 WHEN b.object_type = 67 THEN \u2018ExternalShortcut\u2019 WHEN b.object_type = 68 THEN \u2018ExternalShortcutTarget\u2019 WHEN b.object_type = 69 THEN \u2018Reconciliation\u2019 WHEN b.object_type = 70<br\/><\/span><span lang=\"EN-US\">       THEN \u2018Layer\u2019 WHEN b.object_type = 71 THEN \u2018Palette\u2019 WHEN b.object_type = 72 THEN \u2018Thresholds\u2019 WHEN b.object_type = 73 THEN \u2018PersonalView\u2019 WHEN b.object_type = 74 THEN \u2018FeatureFlag\u2019 ELSE \u2018Unknown\u2019<br\/><\/span><span lang=\"EN-US\">       END AS object_type_desc, Parent_1.OBJECT_NAME AS Name_with_path, REPLACE(Parent_1.OBJECT_NAME, b.OBJECT_NAME, \u2018\u2019)<br\/><\/span><span lang=\"EN-US\">      AS Path_name, b.HIDDEN, dbo.fn_UniqueIdentifierToCharMSTR(a.OBJECT_ID) as OBJECT_ID<br\/><\/span><span lang=\"EN-US\">FROM            dbo.DSSMDOBJSECU AS a INNER JOIN<br\/><\/span><span lang=\"EN-US\">      dbo.DSSMDOBJINFO AS b ON a.OBJECT_ID = b.OBJECT_ID AND a.PROJECT_ID = b.PROJECT_ID  INNER JOIN<br\/><\/span><span lang=\"EN-US\">      dbo.DSSMDOBJINFO AS c ON a.TRUST_ID = c.OBJECT_ID INNER JOIN<br\/><\/span><span lang=\"EN-US\">      dbo.DSSMDOBJINFO AS d ON a.PROJECT_ID = d.OBJECT_ID INNER JOIN<br\/><\/span><span lang=\"EN-US\">      Parent AS Parent_1 ON a.OBJECT_ID = Parent_1.OBJECT_ID AND a.PROJE<i>CT_ID<\/i> = Parent_1.project_id<\/span><\/pre>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8fb1b13 elementor-widget elementor-widget-heading\" data-id=\"8fb1b13\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Conclusions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-516ebae elementor-widget elementor-widget-text-editor\" data-id=\"516ebae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>And just like the cases I have been describing, the possibilities are endless! And of course, it can be a good idea to create views with the queries or to create new objects in our model that allow us to play and navigate with the different queries or those fields that we customize. <\/p>\n<p>Although it is possible <a href=\"https:\/\/bestdatasolutions.es\/en\/blog\/microstrategy-command-manager\/\">to use command manager<\/a> to obtain information, it is much more customizable to do it with a query.<\/p>\n<p>Now it&#8217;s your turn, did you know about these consultations? Are there any you would like to recommend? Have you ever made queries or browsed the Metadata? <\/p>\n<p>So much for this week&#8217;s article. As always, I hope you find this helpful, maybe learn something new, and I invite you to leave comments or topics you&#8217;d like me to write about!<\/p>\n<p>See you next <em>#BestInMicro!<\/em><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d234d7d elementor-widget elementor-widget-heading\" data-id=\"d234d7d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">References<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45d0eb9d elementor-widget elementor-widget-text-editor\" data-id=\"45d0eb9d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: #0081c5;\"><a href=\"http:\/\/khaidoan.wikidot.com\/mstr-metadata-queries\" target=\"_blank\" rel=\"noopener\">Metadata Queries<\/a><\/span><\/p>\n<p><a href=\"https:\/\/www.infocepts.com\/pdf\/Solutions\/BI-Application-Management-and-Optimization\/Key_Metrics_for_Microstrategy_Administrators.pdf\" target=\"_blank\" rel=\"noopener\">Key Metrics for MicroStrategy Administrators<br><\/a><\/p>\n<p><\/p>\n<p><a href=\"https:\/\/doc-archives.microstrategy.com\/producthelp\/10.4\/ProjectDesignGuide\/WebHelp\/Lang_1033\/Content\/ProjectDesign\/MicroStrategy_metadata.htm\" target=\"_blank\" rel=\"noopener\">MicroStrategy metadata<\/a><\/p>\n<p><a href=\"http:\/\/www.bryanbrandow.com\/2011\/03\/detecting-incorrect-security-in-production.html\" target=\"_blank\" rel=\"noopener\">Detecting Incorrect Security in Production<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fa56b1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3fa56b1\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a5606ec elementor-align-center elementor-widget elementor-widget-button\" data-id=\"a5606ec\" 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>The Metadata is where all the MicroStrategy definition is stored. It is a database where the whole &#8220;skeleton&#8221; of the tool is located&#8230;<\/p>\n","protected":false},"author":2,"featured_media":1097,"comment_status":"open","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[73,72],"class_list":["post-3804","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-articulo","tag-microstrategy"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3804","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=3804"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/3804\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/1097"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=3804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=3804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=3804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}