How to dynamically determine which partitions to process?

• femi

  Grasshopper

  Points: 22

  More actions

  March 8, 2013 at 2:40 pm

  #271361

  Hello,

  I have a Tabular model with a partitioned fact table based on date field. I have data in there from jan 1 to jan 10 partitioned daily..thus 10 partitions.

  I now want to process the cube because I have new data for the 11th coming in.

  My questions are;

  1) How do I dynamically ask SSAS to create a fresh partition for day 11?

  2) How do I ask SSAS to process partition 11 ONLY.

  Thanks