Database Reference
In-Depth Information
5. If you open each dimension folder, you'll find a number of files with different
extensions, each of them serving a specific purpose: storing keys, strings, in-
dexes, and so on.
Under the folder with the .cub extension (in the preceding screenshot, the
folder name is AdventureWorksSample.0.cub ), you will find separate
folders for each measure group with the extension .det , and each partition
folder will have the .prt extension.
6. Each partition folder contains partition data files, which are usually the largest
files, along with header and aggregation files. So remember that each Ana-
lysis Services database is a complex structure consisting of cubes, measure
groups, partitions, and many files making up each object.
7. If you have been browsing through files by now, you must have probably
noticed the file version numbers. Analysis Services updates the file version
numbers when the file changes. For example, when you process the promo-
tion dimension, SSAS will increment the file version numbers upon comple-
tion of processing.
8. Similarly, if a database exists on the given SSAS instance, and you synchron-
ize it from another instance, the target database version number will be in-
cremented. Master.vmp stores all the version numbers.
9. If you happen to delete some files or modify version numbers manually while
the server was stopped, the version numbers will not match those found in
master.vmp , and your object will be corrupted. Therefore, if you want to
Search WWH ::




Custom Search