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

  • 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?

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply