Creating Connections

When XLCubed detects that you require a new connection to a cube, or if you manually choose the XLCubed > Connections > Add option, you will have the opportunity to select one of your recently used connections or to create a new one.

Recent Connections

1. On the Recent Connections tab, click the connection you would like to use
2. When you click OK, the selected cube will be added as one of the workbook's current connections

Analysis Services Server

1. On the New Connection tab, select Analysis Services Server from the dropdown control
2. Enter the name of the server in the edit field, then click Connect
3. Select the database from the Databases list
4. Select the cube from the Cubes list
5. When you click OK, the selected cube will be added as one of the workbook's current connections

Analysis Services Cube File

1. On the New Connection tab, select Analysis Services Cube File from the dropdown control
2. Enter the full path to the file, or click the ... button to browse for it, then click Connect
3. Select the database from the Databases list
4. Select the cube from the Cubes list
5. When you click OK, the selected cube will be added as one of the workbook's current connections

See Also

• Managing Connections