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