Creating Your First Multidimensional Cube - Getting Started with SQL Server 2012 Cube Development - page 46

Tip
For a description of what a local cube is, refer to the following link:
http://msdn.microsoft.com/en-us/library/bb522640.aspx
More information about bindings can be found at http://msdn.microsoft.com/en-
us/library/ms128523.aspx .
Inherit is a useful option. If you have several connections in your cube and you want
to maintain the connection information in one place, you can define it on the data-
base level in your project. The database is something that you do not see by de-
fault when you open your project in SQL Server Data Tools. But if you click on the
Show All Files button in Solution Explorer , you will see a new file in your pro-
ject that you can open. This file contains information that is common to all objects
within the project. Here you can define security information that will be inherited by
all other data source objects in your project. This is defined in the property called
<DataSourceImpersonationInfo> .
Tip
More information on how to set this property can be found at ht-
tp://technet.microsoft.com/en-us/library/ms127690.aspx .
Creating the data connection
To create the data connection, perform the following steps:
1. Right-click on the Data Sources folder in the Solution Explorer window.
2. Choose the New Data Source option.
3. The Data Source Wizard window will start with a splash screen and you
need to click on Next .
4. In the Define Connection screen, click on the New button to create a data
source based on a new connection.