Hi All, I need to create package which handles partition processing. The package will process previous 5 Partitions from the current partition in cube. General process is before we proceed to process partitions we need to recreate the view , i,e drop existing view and create view. Hence we need to identify partition in our package then use a execute sql task to recreate the view. After I had created the view I need to process the cube partitions with the script task. Could you please advise me how can I implement the processing logic starting from identifying partions to processing partitions and also which would be the best tasks to accomplish this? Any detailed help will be highly appreciated. Mudassar

what do you mean by partitions? do you mean SSAS measure group's partitions? if yes, you can query to find list of partitions using DMV, here you can read more about DMV: http://msdn.microsoft.com/en-us/library/ms126079.aspx then you can generate the partition processing xmla command with expressions and pass the expression with a package variable to Analysis Service Execute DDL Task to process the partition.http://www.rad.pasfu.com

Yes partitions are cube measure partitions. I read the http://msdn.microsoft.com/en-us/library/ms126079.aspx link but dint find anything in it which tells that it gives partition information of cube measures. In our warehouse we have partition management table which keeps details about partitions . Thanks Mudassar

Hi Mudassar, I suggest You can use Partition Processing Destination, the Partition Processing destination loads and processes an SQL Server Analysis Services partition. it includes the following features: 1. Options to perform incremental, full, or update processing. 2. Error configuration, to specify whether processing ignores errors or stops after a specified number of errors. 3. Mapping of input columns to partition columns. For more information about it, please see: http://msdn.microsoft.com/en-us/library/ms137992.aspx Please feel free to ask if you have any question. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Hi Mudassar, I suggest You can use Partition Processing Destination, the Partition Processing destination loads and processes an SQL Server Analysis Services partition. it includes the following features: 1. Options to perform incremental, full, or update processing. 2. Error configuration, to specify whether processing ignores errors or stops after a specified number of errors. 3. Mapping of input columns to partition columns. For more information about it, please see: http://msdn.microsoft.com/en-us/library/ms137992.aspx Please feel free to ask if you have any question. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.