Database Reference
In-Depth Information
Figure 15-20.
Making a connection to SSAS
You will have verification that you are connecting to SSAS rather than SQL Server on the following screen.
In the dialog window shown in Figure
15-20
, select the cube that you want to use rather than a view or table. Like
tables, cubes are grouped into databases, so you must select the appropriate database before the cube can be
displayed. Figure
15-21
shows that we are connecting to the PubsBICubes database and selecting the cube called
CubePubsSales, which in this case is the only available option.
When you click Next, you will be asked where to save the
.odc
file once again. The default values will work
fine for almost all occasions. Clicking Finish ends the Data Connection Wizard.
