Database Reference
In-Depth Information
If you navigate to the folder where the Visual Studio solution files are located, you will find that there are no
project files associated with them. Instead, the project that you see in Visual Studio's Solution Explorer treeview is
a virtual project.
This is also true of the data source, data source view, cubes, and dimensions. If you look closely at Figure
12-46
,
you will notice that there are no extensions shown in Solution Explorer for each of these objects (as would be
with a standard Visual Studio project). Another difference is that you cannot right-click these object's icons and
use the View Code option from the context menu to see the underlying XML code, because it simply does not
exist for these virtual objects.
Figure 12-46.
Some visual clues indicating a live connection
Just as with any other project, after you have made your changes, save your work. But remember, it is live.
Therefore, there is no need to build and deploy it, because there are no code files to build or deploy to SSAS.
Most options and property settings in the online Visual Studio project are the same for normal, offline, SSAS
projects. Because of this, the techniques that we discussed in Chapters 9 through 12 allow you to perform any
changes necessary, when working in Visual Studio Live.
eXerCISe 12-1. ChaNGING the CUBe'S NaMe
In this exercise, you use a live connection to ssAs to change the name of the dWPubssalesVer1 cube to
CubePubssales. Afterward, the dimensions and cube will have prefixes of dim and Cube, respectively.
Note:
This exercise is important to perform, because later in this topic we refer to the new name!
Open a Live Connection to SSaS
You cannot change the name of a cube from the context menu in sQl server management studio, but you
can in Visual studio. let's use Visual studio to make a live connection to the ssAs server.
