- Getting Started with SQL Server 2012 Cube Development
- Simon Lidberg
- 221字
- 2025-04-04 22:27:18
Hands-on steps for configuring your cube project
To configure the cube project for deployment follow the given steps:
- Click on the Properties button in the Server Explorer window.
- Under Build, specify that you are targeting a Developer Edition deployment server.
- Under Deployment, set the target server as follows:
localhost\multidimensional
. - Click on OK.
- Save the project.
- Go to the Build menu and choose to deploy the project; this will send a series of commands to the Analysis Services instance that you have specified under the Target | Server.
- Open up Management Studio and connect to the Analysis Services instance that you used as the target server.
- Click on the Databases folder and make sure that you have an Analysis Services database called
FirstCube
on your server.
Now we have configured the development environment for project mode development. There is another way that you can develop as well, and that is in online mode. This is something that is rarely used, but it can sometimes be useful when you just would like to make a small change to a calculation in a cube without deploying the entire project to the server. To use the online mode, you go into the File menu and choose to open an Analysis Services database. For the remainder of this book, we will use the project development mode.