Databases Reference
In-Depth Information
.
Define translations for your cube
.
Deploy your cube
To start your hands-on exploration of building a multidimensional model with BI Dev
Studio, you will open a sample project. Download the new FoodMart 2008 sample data-
base at
http://www.e-tservice.com/downloads.html
and restore it into one of the folders
on your computer. Then, navigate to that folder.
Creating a Data Source
The first task of creating your multidimensional model is to create a data source. The data
source is an object that defines the way that Analysis Services connects to the relational
database or other sources.
Creating a New Data Source
You will use the Data Source Wizard to create your data source object. First, you will
choose a data connection. If you are following along with the FoodMart 2008 sample
project, you can use the data connection that appears by default. Or you can define a new
data connection.
Launching the Data Source Wizard
1. Right-click the Data Sources node in the Solution Explorer of BI Dev Studio and
select New Data Source from the menu that appears.
2. The Data Source Wizard appears; it goes without saying that you can skip the
Welcome page.
3. On the Select How to Define the Connection page, you can select an existing
connection under Data Connections.
To define a new connection instead of using an existing one, click New on the Select How
to Define the Connection page of the wizard. Doing so lands you in the Connection
Manager, where you will define that new connection. (There really isn't much defining
going on if you are using an existing connection.)
NOTE
We cannot give you details about what to do in the Connection Manager, because the
user interface looks different depending on the type of data source you are connecting to.
When you are done with the Connection Manager, you will find yourself back in the Data
Source Wizard, on the same page you were on before you were whisked away to the
Search WWH ::
Custom Search