Reading Data from the Data Warehouse during Cube Processing

As most of us know, an SSAS Cube should be processed before creating any analytic reports on it. However, we might overlook what cube processing does and how to read the data from data warehouse (DWH).

This write-up will give you a clear picture of what is happening behind this mysterious cube processing and what detailed queries are submitted to DWH to fetch data.