Database Reference
In-Depth Information
1. It clears all the data that exists in the object, this is the same as executing a
ProcessClear
command.
2. It reads the data from the relational source, this step is called
ProcessData
.
3. After the data has been stored in Analysis Services, the next step is to build
indexes and aggregations, this step is called
ProcessIndex
.
Processing can also be executed in parallel. When you issue a process command
on a high level structure such as the database, Analysis Services automatically de-
termines the objects that need to be processed, and then divides it into smaller tasks
such as processing the dimensions and the cubes in the database separately. All of
these tasks can be executed in parallel and the server will by default choose the best
number of objects to process in parallel. You can also manually control parallelism of
the processing.
Processing the FirstCube project
To process the
FirstCube
database, perform the following steps:
1. In
SQL Server Data Tools
, right-click on the
FirstCube
database in the
Solution Explorer
window and choose
Process
.
Search WWH ::
Custom Search