title: How to incrementally process a SSAS cube for speed-up?
body: <p>What I need is reducing process time of a SSAS cube using AMO while adding data to a fact table in data warehouse.</p>
  
  <p>According to Microsoft document on SSAS:</p>
  
  <p><strong>Process Add</strong></p>
  
  <p>"For dimensions, adds new members and updates dimension attribute captions and descriptions. For measure groups and partitions, adds newly available fact data and process only to the relevant partitions."</p>
  
  <p><strong>Process Full</strong></p>
  
  <p>"Processes an Analysis Services object and all the objects that it contains. When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object, for example, when an attribute hierarchy is added, deleted, or renamed."</p>
  
  <p>Thus with following code, I could have at least similar processing time per record regardless amount of data in data warehouse.</p>
  
  <pre><code>var start = DateTime.Now;
  var query = "SELECT [dbo].[FactGradingResult].* FROM [dbo].[FactGradingResult]  WHERE ([Id] = "+ grading2.Id+")";
  ptn.Process(ProcessType.ProcessAdd,
      new QueryBinding(dsv.DataSourceID, query));
  var end = ptn.LastProcessed;
  swch2 = (end - start).TotalMilliseconds;
  </code></pre>
  
  <p>But the ProcessAdd still takes about 900 ms to update the cube with a single row of fact table. Is this typical time of ProcessAdd of SSAS with a 8-core 2.5GHz machine of Windows Server 2012? If not, how can I improve cube processing time per a row to fact table?</p>