{"id":1387,"date":"2017-01-12T15:15:43","date_gmt":"2017-01-12T09:45:43","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1387"},"modified":"2017-01-12T15:15:43","modified_gmt":"2017-01-12T09:45:43","slug":"calculation-is-ssas-sql-server-analysis-service","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1387","title":{"rendered":"Calculation is SSAS (SQL Server Analysis Service)"},"content":{"rendered":"<p>The error here occurred while doing the SSAS calculations.<\/p>\n<h3>Error:<\/h3>\n<p>Below image is the snapshot from SSAS cube where we are doing calculation and while we are dragging and dropping the measure &amp; dimension fields we cannot see the calculations.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.jpg\" rel=\"attachment wp-att-1388\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1388\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.jpg\" alt=\"1\" width=\"628\" height=\"301\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9-300x144.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>There is a pre calculated script which is present when we make the cube and dimensions due to which we can see the basic calculations. But here as we see that calculated script is missing.<\/p>\n<h3>Solution:<\/h3>\n<p>Now as we know that at the time of making cube and dimensions the calculated script is generated at that time itself. Now during <a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI offline training<\/a> one candidate somehow accidentally deleted the \u201cCalculated\u201d script the cube will not work and therefore we encounter the error as shown above. So we have to make sure that the Default Calculate script is never deleted.<\/p>\n<p><b>The Default Calculate script command helps to calculate aggregation of cube.<\/b><\/p>\n<p>Now if the calculated script is deleted then we can create a new one once again,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-9.jpg\" rel=\"attachment wp-att-1389\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1389\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-9.jpg\" alt=\"2\" width=\"402\" height=\"269\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-9.jpg 402w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-9-300x201.jpg 300w\" sizes=\"(max-width: 402px) 100vw, 402px\" \/><\/a><\/p>\n<p>Or we can do in this way, click on the icon as shown below which is available under Menu bar<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-9.jpg\" rel=\"attachment wp-att-1390\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1390\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-9.jpg\" alt=\"3\" width=\"380\" height=\"116\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-9.jpg 380w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-9-300x92.jpg 300w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/a><\/p>\n<p>Then, we simply write \u201cCalculate\u201din the script window<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-8.jpg\" rel=\"attachment wp-att-1391\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1391\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-8.jpg\" alt=\"4\" width=\"628\" height=\"224\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-8.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-8-300x107.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>And then save and deploy the solution by clicking on Build &gt; Deploy Solution as shown below<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-7.jpg\" rel=\"attachment wp-att-1392\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1392\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-7.jpg\" alt=\"5\" width=\"593\" height=\"285\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-7.jpg 593w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-7-300x144.jpg 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/p>\n<p>After deploying go to the browser, reconnect the browser and then try to take the amount measure and any dimension and we will see the aggregated calculation.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-5.jpg\" rel=\"attachment wp-att-1393\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1393\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-5.jpg\" alt=\"6\" width=\"627\" height=\"301\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-5.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-5-300x144.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>This issue was practical learning example for other candidate of <a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training<\/a> whose unknowingly done mistake helped others to learn as well. Likewise there are other such mistake done and are resolved along with the training syllabus.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The error here occurred while doing the SSAS calculations. Error: Below image is the snapshot from SSAS cube where we are doing calculation and while we are dragging and dropping the measure &amp; dimension fields we cannot see the calculations. &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1387\">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":[163,164,160,162,161],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculation is SSAS (SQL Server Analysis Service) - 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=1387\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculation is SSAS (SQL Server Analysis Service) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"The error here occurred while doing the SSAS calculations. Error: Below image is the snapshot from SSAS cube where we are doing calculation and while we are dragging and dropping the measure &amp; dimension fields we cannot see the calculations. &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1387\" \/>\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-12T09:45:43+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.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=1387#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1387#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1387\",\"name\":\"Calculation is SSAS (SQL Server Analysis Service) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1387#primaryimage\"},\"datePublished\":\"2017-01-12T09:45:43+00:00\",\"dateModified\":\"2017-01-12T09:45:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1387#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1387\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1387#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calculation is SSAS (SQL Server Analysis Service)\"}]},{\"@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":"Calculation is SSAS (SQL Server Analysis Service) - 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=1387","og_locale":"en_US","og_type":"article","og_title":"Calculation is SSAS (SQL Server Analysis Service) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"The error here occurred while doing the SSAS calculations. Error: Below image is the snapshot from SSAS cube where we are doing calculation and while we are dragging and dropping the measure &amp; dimension fields we cannot see the calculations. &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1387","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2017-01-12T09:45:43+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.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=1387#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-9.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1387#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1387","name":"Calculation is SSAS (SQL Server Analysis Service) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1387#primaryimage"},"datePublished":"2017-01-12T09:45:43+00:00","dateModified":"2017-01-12T09:45:43+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1387#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1387"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1387#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Calculation is SSAS (SQL Server Analysis Service)"}]},{"@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\/1387"}],"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=1387"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1387\/revisions"}],"predecessor-version":[{"id":1394,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1387\/revisions\/1394"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}