Slicing Analysis Services (SSAS) Partitions and more
Just wanted to touch base on a couple of items with partitions referencing the ever popular Adventure Works 2008 sample Analysis Service project available to download from CodePlex here – SQL Server 2008 SR1 downloads – it appears that they have bundled the databases together now, used to be broken out by the operational and the data warehouse. The sample project file will be part of this download for Analysis Services and will be located in the following directory if you go with the default setup - C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project.
Now if you open up the Enterprise version you will see that the measures groups have multiple partitions defined for them. One thing to note is that the counts are not properly updated and that aggregations have not been defined for all partitions in the cube.
Read more...Tags: management