how to dynamically place the patition - Analysis Services

Learn Microsoft BI Forum Core Servers Analysis Servic... how to dynamically place the patition

6/21/2009 6:02 PM

how to dynamically place the patition

Hi Craig, i watched your video in partition and at some point you menthined that your client used to do patition based on week to date data.

How it is possible to do dymanically do the partition based on week to Date AND THEN MERGED THAT INTO monthly partition dynamically nt manually.

Thank you

6/21/2009 8:03 PM

Re: how to dynamically place the patition

The only way to do these things automatically is to code it, either in a .NET app, SSIS, or something similar. Here is an example in SSIS using the Script task: http://www.ssas-info.com/VidasMatelisBlog/13_ssis-package-to-dropcreate-partitions-based-on-partition-list-in-the-sql-server-table

Page 1 of 1