Understanding OLAP Processing
In this section, you’ll learn what happens when you process an Analysis Services database. This includes looking at how the Analysis server processes a dimension as well as how the server processes a cube. You’ll learn what happens to client applications while the server is processing a database, and you’ll learn what happens when the data warehouse changes and you haven’t processed the OLAP database.
How the Analysis Server Processes a Dimension
When you process a dimension, the Analysis server creates a SQL statement to extract the necessary information from the data warehouse dimension table. The extract includes one or two columns for each level in the hierarchy. (If the Member Name Column property for a level ...