You should analyze the return result of the Process command from the bottom up. The
last error is usually is the one that caused the processing to fail. The rest of the errors
usually report from higher levels of execution.
Error handling is a costly operation. It could take some time for every processing thread
to notice the cancel flag raised by another thread. Some of the threads could be sleeping,
waiting for some resource to become available, and therefore not checking for any flag at
all. For example, a Read Data thread can go into the sleep state waiting for a SQL query
result.
Summary
Analysis Services enables you to access data only after you create a multidimensional
model and populate it with data. The operation of loading the data from the ...