Examining cube file structures
It's time to take a break from SSDT and check what's happening under the hood. Unlike other database platforms, each SSAS database consists of many files. Analysis Services does not expose its transaction log, nor does it have system databases as master or tempdb. Instead, all of the metadata for the entire server resides in the master.vmp file, which you cannot read or modify. You don't have to know what's within each database file, but knowing Analysis Services' database file structures can be very helpful during troubleshooting.
How to do it...
Let's get started; perform the following steps to examine the cube file structure:
- Each of the Analysis Services instances is associated with a data folder, which stores files ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
