{"id":622,"date":"2014-01-15T17:06:06","date_gmt":"2014-01-15T23:06:06","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=622"},"modified":"2024-06-26T01:25:36","modified_gmt":"2024-06-26T06:25:36","slug":"ssas-cube-partition-slice-errorcode3240034361","status":"publish","type":"post","link":"http:\/\/cognitiveinfo.com\/?p=622","title":{"rendered":"SSAS Cube Partition Slice ErrorCode=&#8221;3240034361&#8243;"},"content":{"rendered":"<figure id=\"attachment_626\" aria-describedby=\"caption-attachment-626\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2014\/01\/SSAS-Slice.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-626\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2014\/01\/SSAS-Slice-300x268.png\" alt=\"SSAS Cube Partition Properties. Slice Property is highlighted.\" width=\"300\" height=\"268\" \/><\/a><figcaption id=\"caption-attachment-626\" class=\"wp-caption-text\">SSAS Cube Partition Properties. Slice Property is highlighted.<\/figcaption><\/figure>\n<p>Slices are a great way to improve query performance in a heavily partitioned SSAS Cube.\u00a0 The photo above shows where to add or change a Slice properties in partition properties dialog box.<\/p>\n<p>If you ever get the following errors when processing cubes, it has to do with the Slicer property at the partition level.\u00a0 The first error message tells you it is a slicer, the next few messages will indicate which partition puked. This post is sponsored by our partners <a href=\"https:\/\/www.high-endrolex.com\/\">Wigs<\/a><\/p>\n<pre>&lt;Error ErrorCode=\"3240034361\" \nDescription=\"Errors in the OLAP storage engine: \n<strong>The restrictions imposed on partition slice where violated.<\/strong>\" \nSource=\"Microsoft SQL Server 2012 Analysis Services\" HelpFile=\"\" \/&gt;<\/pre>\n<pre>\u00a0&lt;Error ErrorCode=\"3240034318\" Description=\"Errors in the OLAP storage engine: \n<strong>An error occurred while processing the 'FY2017Q3' partition<\/strong> \nof the 'InternetSales' measure group \nfor the 'MyCube' cube \nfrom the AdventureWorks database.\" \nSource=\"Microsoft SQL Server 2012 Analysis Services\" HelpFile=\"\" \/&gt;<\/pre>\n<p>Basically,\u00a0 SSAS will not assign a slicer to the partition unless the slice already exists in the Dimension.\u00a0 Since our time dimension is filtered to only valid sales dates, there will be no slices available for future dates.<\/p>\n<p>The problem is that this means we need to add Slicer properties to the newly built partition each quarter.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>f you ever get the following errors when processing cubes, it has to do with the Slicer property at the cube partition level.  Error ErrorCode=&#8221;3240034361&#8243; Description=&#8221;Errors in the OLAP storage engine:<br \/>\nThe restrictions imposed on partition slice where violated.&#8221; Source=&#8221;Microsoft SQL Server 2012 Analysis Services&#8221;<\/p>\n","protected":false},"author":2,"featured_media":626,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[64,98,100],"class_list":["post-622","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ssas","tag-microsoft-sql","tag-sql-ssas","tag-ssas"],"_links":{"self":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=622"}],"version-history":[{"count":1,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/622\/revisions"}],"predecessor-version":[{"id":1236,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/622\/revisions\/1236"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=622"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}