SSAS task processAdd question
Hi, I've been doing some tests and im not sure of the info I've found online. The first problem is that I can't get the processAdd option appear when configuring my dimensions although I've already process my cube with full processing twice, is there
anything else I need to check ?
Also, I have dimensions that may change (only insertions no deletions or updates), will a process Data or process add work on the dimensions followed by a process incremental on the partitions, and a process index on the old ones not being modified
?
Is it a good plan ? cuz im not sure if when I do a process add or process data on the dimensions the measure groups get modified (new aggregations added)
Thanks
April 7th, 2011 4:25pm
do I have to modified the xmla ? is that the only way ?
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2011 6:16pm
ProcessAdd is only available as an XMLA command.
Check the
SQL Server 2008 White Paper: Analysis Services Performance Guide section 5.2 Dimension- Processing Commands for the insides of the Process Dimension commands.
Hope that helps...
April 8th, 2011 10:51am