Database Reference
In-Depth Information
5. Switch back to the Process Dimension dialog, and click on the Change Set-
tings button. The resulting dialog has two tabs: Processing options and Di-
mension key errors .
6. The first processing option allows you to process objects in parallel or se-
quence. Since you're currently processing a single dimension, this option
doesn't make a difference to our processing. However, if you were process-
ing multiple dimensions, you could specify how many of them should be pro-
cessed in parallel. If you change the degree of parallelism to 3 , the XMLA
statement will include the following tag after the <Batch> command:
<Parallel MaxParallel="3">
7. Should you choose the Sequential button, you will see the multiple options to
process all the objects in a single transaction, or to create a separate transac-
tion for each object. Choosing separate transactions adds the following string
to the <Batch> command:
Transaction="false"
8. Unfortunately, SSMS Object Explorer does not provide a graphical option
for processing multiple dimensions at the same time. However, now that
you've seen the <Batch> command processing a single dimension, it won't
be difficult to extend it to include three dimensions, as shown in the following
code snippet. Though this might seem like a lot of code, it simply repeats
the <Process> command while substituting the identifier for the Promotion ,
Account , and Geography dimensions:
<Batch xmlns =
"http://schemas.microsoft.com/
analysisservices/2003/engine">
<Parallel MaxParallel="3">
<Process>
<Object>
<DatabaseID>AdventureWorks_Sample</DatabaseID>
<DimensionID>Dim
Geography</DimensionID>
</Object>
<Type>ProcessUpdate</Type>
Search WWH ::




Custom Search