Databases Reference
In-Depth Information
The key to an OLAP database is the fast access to data. You learned about a
cell, which was represented by a Tuple. A Tuple is the intersection of various
dimension members. For fast data access, Analysis Services builds indexes
to access data across multiple dimensions. The index files in Analysis Ser-
vices have the extension "map." In
Figure 12-9
you can see the .map files
that have the format <version>.<Dimension>.<Hierarchy>.fact.map. There is
an associated header file for each map file. Analysis Services stores the data
as blocks called segments for fast access. The associated header file con-
tains offsets to the various segments for fast access during queries.
Figure 12-9
The processing dialog provides you the flexibility of processing objects in par-
allel or within the same transaction. If errors are encountered during process-
ing, you can set options to handle these errors. You can configure the paral-
lelism and error options by selecting the Change Settings button in the pro-
cess dialog. You will see the Change Settings dialog as shown in
Figure
12-10
which enables you to configure certain processing operations and error
settings during processing. Setting the parallelism option is as simple as se-
lecting the appropriate option in the processing order. By default all the ob-
jects are processed in parallel and within the same transaction. If you do want
failure of one object to impact other objects, you should process the objects
under different transactions by choosing the sequential option.
Search WWH ::
Custom Search