Building Basic Dimensions and Cubes - Expert Cube Development with SSAS Multidimensional Models - page 37

Here is a list of properties you may want to change at the project level, and the
values you can set for them:

• Build : The following properties can be changed on the Build tab:

° Deployment Server Edition : If you plan to deploy Standard Edition
in production, but you're using Developer Edition in development,
you will want to set this property to Standard . This will make SSDT
raise errors when you build a project if you accidentally use features
that aren't available in the Standard Edition.

• Deployment : The following properties can be changed under the

Deployment tab:
° Processing Option : This property allows you to process your
database automatically whenever you deploy a project. The Default
option will perform a Process Default, but in many cases, when
you deploy a change that doesn't need any cube processing at all, a
Process Default can still waste 10 or 20 seconds, and if you've made
more substantial changes to an object you will still want to control
when processing takes place. Setting this property to Do Not Process
instead will stop all automatic processing. This means that you
have to remember to manually process any objects yourself if you
make changes to them, but it will save you time in the long run by
preventing a lot of unintentional processing.
° Server : This contains the name of the server you're deploying to and
defaults to localhost . If you're not developing on a local Analysis
Services instance, then you'll need to change this anyway. Even if
you are, it's a good idea to enter the name of the target server, rather
than use localhost , in case anyone wants to work on the project on
another machine.
° Database : This contains the name of the database that you're
deploying to. It defaults to the name of the Visual Studio project.
Of course, you can change it if you want your project and database
to have different names.

We'll be looking again at how Visual Studio project configurations can help
you when you need to deploy your project to your production environment
in Chapter 10 , Going in Production .