Report Portal

Parallelize ProcessAdd with AMO

In this article we see a function to enable parallelism in commands sent to Analysis Services by using the AMO library even when you need to use the change the QueryBinding. This function is useful because the current AMO library (up to SQL Server 2012) cannot correctly generate the required XMLA code if multiple commands using QueryBinding are executed within the same batch.

When you want to implement an incremental process using ProcessAdd, chances are that you want to change the QueryBinding within the ProcessAdd command, because you put directly in the SQL code the WHERE condition in order to extract only new rows from the data source.

Read more...

Tags: management, amo, process

 

2007-2015 VidasSoft Systems Inc.