I have created partitions in my tabular model for the next few years by quarter. I would like to process full the partitions as we load data each month by modifying the SQL for the partition.
My thought was to modify the XMLA script, altering the partition SQL in a script task. Is it possible to modify the SQL for a partition that's been created? If not, how do I determine which partition to process within SSIS?
I would like to process full the partitions as we load data each month by modifying the SQL for the partition.
Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog
We can create a SSIS package and use Analysis Services Execute DDL task to process Tabular partitions. Here are some articles for your reference, please see:
SSIS Methods to Process SSAS Tabular Partitions: http://jessekraut.wordpress.com/2013/09/24/ssis-methods-to-process-ssas-tabular-partitions/
TechNet Community Support
This is link is a useful reference. It shows how you can execute a specific partition that has been created and process that partition using c# script.
So if like the example I had partitions for sales 2008, 2009 and 2010, and I was loading data for 2009. How would I know the name of the 2009 partition to execute? The partition id is stored in a variable but I'm not sure how to modify the variable value with corresponding partition for the year of data I am loading.