Microsoft® SQL Server 2012 Unleashed

Building and Deploying the Cube

You basically have a cube definition now, but it is just an empty shell. You need to process it and then deploy it so that it is instantiated and populated with data (via the data source view). Remember that this cube definition is a solution project, just like a C# code project. It must be deployed before it can be used. First, you need to verify that the properties of the cube you are building are set correctly. You must have these properties correct before the cube can be processed. (Process, in this case, means build the cube structure and populate the measures and their associated dimensions.) You can assume that the properties will not be set correctly, so you should take a quick look and update them accordingly. ...