SSAS Cube Partition Slice ErrorCode=”3240034361″

SSAS Cube Partition Slice ErrorCode=”3240034361″

  Slices are a great way to improve query performance in a heavily partitioned SSAS Cube.  The photo above shows where to add or change a Slice properties in partition properties dialog box. If you ever get the following errors when processing cubes, it has to do with the Slicer property at the partition level.  The first error message tells you it is a slicer, the next few messages will indicate which partition puked. <Error ErrorCode="3240034361" Description="Errors in the OLAP storage engine: The restrictions imposed on partition slice where violated." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />  <Error ErrorCode="3240034318"…
Read More