Video - SSAS database folder structure

This presentation introduces to structure of SSAS MOLAP database folder. These videos explains:

• How to find when SSAS dimension was last processed
• How to find what is the size of SSAS dimension or even attribute
• How to find when SSAS partition was processed
• How to find what is the size of SSAS Cube, Measure Group or partition
• How to find how much space in partition is used by data, aggregations or attribute indexes
• Why you need to process cube indexes after dimension attribute values change and you process dimension with ProcessUpdate command

SSAS folder data structure - Part 1 - Introduction (by Vidas Matelis)

First part of presentation for SSAS MOLAP data folder structure. First part introduces to SSAS data folder structure and shows what happens after new SSAS database is deployed.

SSAS folder data structure - Part 2 - DB Corruption (by Vidas Matelis)

Second part of presentation for SSAS MOLAP data folder structure. This part explains how to recover from SSAS database corruption.

SSAS folder data structure - Part 3 - After processing (by Vidas Matelis)

Third part of presentation for SSAS MOLAP data folder structure. This part explains how information is stored inside database folder after processing.

SSAS folder data structure - Part 4 - Dimension ProcessUpdate (by Vidas Matelis)

Fourth part of presentation for SSAS MOLAP data folder structure. This part explains how indexes and flexible aggregations are dropped after doing ProcessUpdate on dimension when attribute values changed.