Database Reference
In-Depth Information
In this dialog window, you can adjust or reselect the columns, reverse relationship direction, or determine
that the relationship consists of multiple columns.
Now that you know how to create a data source and data source view, let's create both on your machine
using the steps outlined in Exercise 9-1.
eXerCISe 9-1 CreatING a Data SOUrCe aND Data SOUrCe VIeW
in this exercise, you add a new SSAS project to your current Visual Studio Solution and create a new data
source and data source view within the project. once completed, your SSAS project should look similar to
Figure
9-33
.
Figure 9-33.
The Edit Relationship dialog window
add an SSaS project to an existing Solution
1.
open Business intelligence Development Studio, and select Start ➤ All
Programs ➤ Visual Studio 2010.
Important:
Remember to right-click the menu item and select Run as Administrator and answer Yes to close
the UAC.
2.
open the
PublicationsIndustries.sln
file you have been working on in the
previous chapter by selecting File ➤ open ➤ Project/Solution from the main menu at
the top of Visual Studio. When the open Project dialog window opens, navigate to the
