Database Reference
In-Depth Information
the files in your project for editing. By default it will open in the visual editor that lets
you work with the object in a visual editor, but if you right-click on an object you can
open up and view the source code for the object.
Properties window
When developing Analysis Services' cubes, you will spend a lot of time in the Prop-
erties window. Every single object such as an attribute or a dimension has different
properties that can be used to change the behavior of the object. Depending on what
object you have highlighted in either the Solution Explorer window or in the main
window, the Properties window displays the relevant properties. If you find it hard to
navigate around the different properties, you should be aware of the sorting feature
of the Properties window. This allows you to either view the properties by categor-
ies, or sorting them by name.
Build menu
All the changes that you do in SQL Server Data Tools are local to the project itself.
This means that you will not see anything on the server until you build and deploy
your project to the server. To be able to build and deploy the project, you have to
specify the build settings. These settings are the properties of the project. You can
click on the Properties button in the Solution Explorer window, or use the Project
menu to access the project properties.
The first important setting is on the Build menu, where you can target the server
edition that you wish to deploy to. SQL Server comes in three major editions, and
they are Standard, Business Intelligence, and Enterprise Editions. You also have a
separate edition for developers that contains the same feature set as Enterprise Edi-
tion. When it comes to Analysis Services, there are some features that the Standard
Edition does not have that are in the other editions. To make sure that you do not try
and develop a solution that contains features that are not available in your edition,
you have the ability to set the target server edition.
Search WWH ::




Custom Search