Adding a column to cube partitions ( after successfully adding it to relational store / Data Source Views )

• j-484180

  SSC Enthusiast

  Points: 123

  More actions

  February 10, 2011 at 6:44 am

  #144587

  So, have added the column to the relational store, gotten it updated in the DataSourceViews.

  Then, it has to get into the cube's partition definitions. We have one for every day for years. Please tell me that there is a way to add this column without touching every partition either through the ide or code? Is there nothing built into BIDS?

  And guessing the answer is touch every partition, does everyone out there then basically develop with a very small # of partitions so that they can make changes in a reasonable amount of time?

• Kees Beimans

  SSC Eights!

  Points: 978

  More actions

  February 13, 2011 at 12:54 pm

  #1286184

  What do you want the easy, the automatic or the hard way..

  One the easy;

  Save the partition designs in SMSS into a XMLA file. Alter the XMLA by changing the partition sql statements.

  And add new ones by copying those for instance in Excel.:w00t:

  see also: http://tinyurl.com/generatepartitions

  This is better than, walking through each partition..in BIDS..

  There are various methods automating partition design through SSIS scripting. This uses the AMO (Analysis Management Object) Model.http://consultingblogs.emc.com/jamiethomson/archive/2008/09/15/ssis-create-analysis-services-partitions-from-a-ssis-package.aspx

  AMO can be used in PowerShell too,

  There is also a codeplex project

  http://tinyurl.com/autopartition

  So many ways to automate partition design within SSAS. You are not alone...:Whistling:

  Regards Kees