How to Partition Cube – using C#
June 3, 2009
1 comment
There are many different ways you can partition a cube. Here I am talking about – how you can use C# to partition a cube from a DTS package?
Using Microsoft.AnalysisServices Object API, you can travel the whole Hierarchy of objects and completely administer an Analysis Service Instance. From the connection Object you can get to the Server and database instances. And in database you can transverse the Cube and their different measures. Once you get hold of a measure then you can transverse the different partitions of measures and dig deep in to each partition query definitions etc.
Read more…
Categories: Analysis Server, C#, SQL
C#, Cube, Cube Partition, SQL, SQL Analysis Server