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