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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics