SSAS Partition Slicinghttp://blogs.msdn.com/sqlcat/archive/2007/03/05/ssas-partition-slicing.aspxSummary: SSAS uses partitions to contain cube data. Small cubes might use only one, but for non trivial cubes, cube designers will create partitions based on ease of managing data and to split groups of data. This document discusses how the server usesen-USCommunityServer 2.1 SP1 (Build: 61025.2)re: SSAS Partition Slicinghttp://blogs.msdn.com/sqlcat/archive/2007/03/05/ssas-partition-slicing.aspx#5056193Sat, 22 Sep 2007 18:39:08 GMT91d46819-8472-40ad-a661-2c78acb4018c:5056193garyf123<p>Does this mean it is using the slice or not?</p> <p>The &quot;0&quot; means no granularity for that attribute.</p> <p>I have my cube partitioned but it is still scanning the partitions...</p> <p>Dimension 0 [Dim Num Bedroom] (0) &nbsp;[Num Bedrooms]:0</p> <p>Dimension 1 [Dim Property Type] (0) &nbsp;[Property Type]:0</p> <p>Dimension 2 [Dim Square Feet] (0) &nbsp;[Square Feet]:0</p> <p>Dimension 3 [Dim Year Built] (0) &nbsp;[Year Built]:0</p> <p>Dimension 4 [Dim Year Sold] (0) &nbsp;[Year Sold]:0</p> <p>Dimension 5 [Dim Num Bath] (0) &nbsp;[Num Baths]:0</p> <p>Dimension 6 [Dim LotSize SQFT] (0) &nbsp;[LotSize SQFT]:0</p> <p>Dimension 7 [Dim Geo] (0 * 0 0 0 0 0 0 0 0 0 0) &nbsp;[Zip Plus4]:0 &nbsp;[State]:* &nbsp;[State Full Name]:0 &nbsp;[State Median]:0 &nbsp;[Nation Median]:0 &nbsp;[County Name]:0 &nbsp;[County Median]:0 &nbsp;[City]:0 &nbsp;[City Median]:0 &nbsp;[Zip Code]:0 &nbsp;[Zip5 Median]:0 &nbsp;[Zip Plus4 Median]:0</p> <p>Dimension 8 [Dim Lat 4] (-) &nbsp;[Lat Level4]:-</p> <p>Dimension 9 [Dim Long 4] (-) &nbsp;[Long Level4]:-</p> <p>Dimension 10 [Dim Lat] (0 0 0 0 0) &nbsp;[Lat Level4]:0 &nbsp;[Lat Level2]:0 &nbsp;[Lat Level1]:0 &nbsp;[Lat Level0]:0 &nbsp;[Lat Level3]:0</p> <p>Dimension 11 [Dim Long] (0 0 0 0 0) &nbsp;[Long Level4]:0 &nbsp;[Long Level2]:0 &nbsp;[Long Level1]:0 &nbsp;[Long Level0]:0 &nbsp;[Long Level3]:0</p>Analysis Services partition slicehttp://blogs.msdn.com/sqlcat/archive/2007/03/05/ssas-partition-slicing.aspx#8398946Wed, 16 Apr 2008 15:27:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:8398946Radim.NET<p>When you have more than one partition in your cube, you should consider using Slice property(highlight</p>