Database Reference
In-Depth Information
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
<Process>
<Object>
<DatabaseID>AdventureWorks_Sample</DatabaseID>
<DimensionID>Dim
Account</DimensionID>
</Object>
<Type>ProcessUpdate</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
<Process>
<Object>
<DatabaseID>AdventureWorks_Sample</DatabaseID>
<DimensionID>Dim
Promotion</DimensionID>
</Object>
<Type>ProcessUpdate</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Tip
If you would like to process multiple dimensions in parallel using SSMS,
open the
Object Explorer Details
window by pressing the
F7
button on
your keyboard or by navigating to
View
|
Object Explorer Details
. This
window allows you to hold down the
Shift
key and select multiple dimen-
sions at the same time. Once you choose multiple dimensions, you can
either process or delete them using a single command.
9. SSDT allows processing multiple dimensions using a single batch. Simply
click on multiple dimensions while holding down the
Shift
key and choose
Search WWH ::
Custom Search