Processing objects in Analysis Services
In order for users to be able to access your cube and query it, you also need to process it. Processing the cube is the series of steps when Analysis Services reads data from the data sources and stores it as a structure within the server. Processing is a step that can take considerable time if you work with large data volumes. It will execute a select against all tables that are used as dimensions or fact tables in the data source view.
Processing can either be done interactively when deploying the cube or as a separate step using SQL Server Management Studio. You also have the possibility to schedule processing using SQL Server Integration Services or SQL Agent. This is the most common way of processing databases when you run Analysis Services in production.
Processing is actually just a XMLA command itself, the code that is necessary to execute to process the FirstCube
database looks like the following:
<!--Query 4.1--> <Batch xmlns="http...