Database Reference
In-Depth Information
Processing
objects
in
Analysis
Services
In order for users to be able to access your cube and query it, you also need to pro-
cess it. Processing the cube is the series of steps when Analysis Services reads data
from the data sources and stores it as a structure within the server. Processing is a
step that can take considerable time if you work with large data volumes. It will ex-
ecute a select against all tables that are used as dimensions or fact tables in the data
source view.
Processing can either be done interactively when deploying the cube or as a separate
step using SQL Server Management Studio. You also have the possibility to schedule
processing using SQL Server Integration Services or SQL Agent. This is the most
common way of processing databases when you run Analysis Services in production.
Processing is actually just a XMLA command itself, the code that is necessary to ex-
ecute to process the
FirstCube
database looks like the following:
<!--Query 4.1-->
<Batch xmlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<Parallel>
<Process>
<Object>
<DatabaseID>FirstCube</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processingactuallyconsistsofseveralstepsintheserveritself,ifyou,asanexample,
issue a
ProcessFull
command against an object in Analysis Services, it executes
the following commands:
Search WWH ::
Custom Search