| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Managing Connections
Revision as of 15:03, 12 April 2013 by Antonio.remedios (talk | contribs) (Added as2000 connection type)
The Manage Connections form is available from the XLCubed > Connections ribbon or menu item.
It allows you to view, edit and delete existing connections for the workbook, and to create new connections when required.
One workbook can support multiple connections to different server / database / cube combinations.
Connecting to your data
One workbook can support multiple connections to different server / database / cube combinations.
Connection Manager
- To make a connection select XLCubed, Connections and press Add
- The display shows any recent connections, which can quickly be re-used by selecting and pressing OK
- For a new connection, select the New Connection tab, choose the server type and specify the appropriate detail as below:
- Analysis Services Server: Type the server name
- Analysis Services Server 2000: Type the AS2000 server name
- Analysis Services Cube file: Browse to locate the local cube file
- XLCubed Connection: Type the URL of the XLCubed Web Edition server to connect to
- Once connected, select the required database on the left, then select relevant cube on the right to add the connection.
- Add additional connections to the workbook as required.
