Databases Reference
In-Depth Information
You can clear the data in the cube using the
Unprocess
option. The
Process
Script Cache
option can be used when you want Analysis Services to cache
the calculations specified in the MDX script. Analysis Services evaluates cal-
culations specified using the CACHE statement in the MDX scripts. You have
learned the various processing options for the Cube. The processing options
provided in the process dialog are different than the process types that are
specified in the process command sent to Analysis Services. The following
table shows how the various processing options map to the process types
sent to Analysis Services.
Process Options in Process Dia-
log
Process Type in Process Com-
mand
Process Full
ProcessFull
Process Default
ProcessDefault
Process Data
ProcessData
Process Structure
ProcessStructure
Unprocess
ProcessClear
Process Index
ProcessIndexes
Process Incremental
ProcessAdd
Process Script Cache
ProcessScriptCache
The processed data of a cube are stored in a hierarchical directory structure
that is equivalent to the structure you see in the object explorer.
Figure 12-9
shows the directory structure of the processed data of the Adventure Works
DW sample database in Analysis Services 2005. The directory also shows
the files within a partition. The metadata information about the cubes and di-
mensions are stored as XML files, while the data is stored in a proprietary
format of Microsoft. Every time an object is processed, a new version number
is appended to the object. For example, the files shown in
Figure 12-9
are un-
der a specific partition directory. The file info.<versionnumber>.xml is used to
store the metadata information about the partition. Similar metadata files are
stored within the directories of each object, cube, dimension, and measure
groups. We recommend you to browse through each object folder to see the
metadata information. The fact data is stored in the file with extension data.
Search WWH ::
Custom Search