{"id":1466,"date":"2017-01-31T15:55:55","date_gmt":"2017-01-31T10:25:55","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1466"},"modified":"2017-01-31T15:55:55","modified_gmt":"2017-01-31T10:25:55","slug":"what-is-xmla-in-ssas","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1466","title":{"rendered":"What is XMLA in SSAS?"},"content":{"rendered":"<p>This write-up will brief in XMLA and where do we get to see it in SSAS. This write-up is inspired from\u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training<\/a> and written by one of the attendee of past MSBI class conducted in Mumbai. So basically XMLA is a type of query language like the MDX and the DMX. The main purpose of this XMLA is to do SSAS administrative jobs like backing up the cube, processing the cube, etc. So in short XMLA is an administrative Query language.<\/p>\n<p><b>How can we get the XMLA query of a Cube?<\/b><\/p>\n<ul>\n<li>To get the XMLA query or to see how the query looks like, what we have to do is that go to our cube right click on it and select the option process. And then the option will appear on top for getting the XMLA query.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg\" rel=\"attachment wp-att-1467\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1467\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg\" alt=\"1\" width=\"247\" height=\"356\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg 247w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16-208x300.jpg 208w\" sizes=\"(max-width: 247px) 100vw, 247px\" \/><\/a><\/p>\n<p>Once Process Cube is open then click on Script Action to New Query Window<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-16.jpg\" rel=\"attachment wp-att-1468\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1468\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-16.jpg\" alt=\"2\" width=\"624\" height=\"473\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-16.jpg 624w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-16-300x227.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Below shown is the XMLA Query<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-15.jpg\" rel=\"attachment wp-att-1469\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1469\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-15.jpg\" alt=\"3\" width=\"623\" height=\"197\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-15.jpg 623w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-15-300x95.jpg 300w\" sizes=\"(max-width: 623px) 100vw, 623px\" \/><\/a><\/p>\n<p>Fundamentals are theory part many candidate feels boring during lecture so to make \u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training<\/a> more interesting we have ensured to associate practical with it so that class become more interesting.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This write-up will brief in XMLA and where do we get to see it in SSAS. This write-up is inspired from\u00a0MSBI training and written by one of the attendee of past MSBI class conducted in Mumbai. So basically XMLA is &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1466\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[106],"tags":[121,178,109,108,120,177],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is XMLA in SSAS? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stepbystepschools.net\/?p=1466\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is XMLA in SSAS? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"This write-up will brief in XMLA and where do we get to see it in SSAS. This write-up is inspired from\u00a0MSBI training and written by one of the attendee of past MSBI class conducted in Mumbai. So basically XMLA is &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1466\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-31T10:25:55+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"StepByStepSchoolsSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\",\"url\":\"https:\/\/www.stepbystepschools.net\/\",\"name\":\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"description\":\"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stepbystepschools.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1466#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1466#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1466\",\"name\":\"What is XMLA in SSAS? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1466#primaryimage\"},\"datePublished\":\"2017-01-31T10:25:55+00:00\",\"dateModified\":\"2017-01-31T10:25:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1466#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1466\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1466#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is XMLA in SSAS?\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\",\"name\":\"StepByStepSchoolsSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"caption\":\"StepByStepSchoolsSupport\"},\"url\":\"https:\/\/www.stepbystepschools.net\/?author=40\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is XMLA in SSAS? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stepbystepschools.net\/?p=1466","og_locale":"en_US","og_type":"article","og_title":"What is XMLA in SSAS? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"This write-up will brief in XMLA and where do we get to see it in SSAS. This write-up is inspired from\u00a0MSBI training and written by one of the attendee of past MSBI class conducted in Mumbai. So basically XMLA is &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1466","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2017-01-31T10:25:55+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"StepByStepSchoolsSupport","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.stepbystepschools.net\/#website","url":"https:\/\/www.stepbystepschools.net\/","name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","description":"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stepbystepschools.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/?p=1466#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-16.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1466#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1466","name":"What is XMLA in SSAS? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1466#primaryimage"},"datePublished":"2017-01-31T10:25:55+00:00","dateModified":"2017-01-31T10:25:55+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1466#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1466"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1466#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"What is XMLA in SSAS?"}]},{"@type":"Person","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655","name":"StepByStepSchoolsSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","caption":"StepByStepSchoolsSupport"},"url":"https:\/\/www.stepbystepschools.net\/?author=40"}]}},"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1466"}],"collection":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1466"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1466\/revisions"}],"predecessor-version":[{"id":1470,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1466\/revisions\/1470"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}