{"id":798,"date":"2013-01-09T20:36:41","date_gmt":"2013-01-09T20:36:41","guid":{"rendered":"http:\/\/www.darrencoupland.com\/blog\/?p=798"},"modified":"2013-01-19T16:23:42","modified_gmt":"2013-01-19T16:23:42","slug":"ssas-no-data-in-cube-after-processing-successfully","status":"publish","type":"post","link":"https:\/\/www.darrencoupland.com\/blog\/2013\/01\/ssas-no-data-in-cube-after-processing-successfully\/","title":{"rendered":"SSAS No data in cube after processing successfully"},"content":{"rendered":"<p>If you&#8217;ve ever processed a cube then browsed it and there&#8217;s no data in there one of the common resolutions is to check that the word &#8216;CALCULATE&#8217; exists in the Calculations tab within the Cube Designer in BIDS as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-801\" title=\"SSAS-Calculate\" src=\"http:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2013\/01\/SSAS-Calculate.jpg\" alt=\"\" width=\"814\" height=\"133\" srcset=\"https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2013\/01\/SSAS-Calculate.jpg 814w, https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2013\/01\/SSAS-Calculate-300x49.jpg 300w, https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2013\/01\/SSAS-Calculate-500x81.jpg 500w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><\/p>\n<p>If it doesn&#8217;t exist then add and re-process your cube.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>If you&#8217;ve ever processed a cube then browsed it and there&#8217;s no data in there one of the common resolutions is to check that the word &#8216;CALCULATE&#8217; exists in the Calculations tab within the Cube Designer in BIDS as shown below: If it doesn&#8217;t exist then add and re-process your cube.<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,50],"tags":[60,62],"class_list":["post-798","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-ssas","tag-sql-server","tag-ssas"],"_links":{"self":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/comments?post=798"}],"version-history":[{"count":3,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/798\/revisions"}],"predecessor-version":[{"id":803,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/798\/revisions\/803"}],"wp:attachment":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/media?parent=798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/categories?post=798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/tags?post=798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}