Connect to your data in Anaplan XL Reporting

You can view, edit and delete existing connections for the workbook, and create new connections.

Use the Manage Connections form to create or modify connections. Manage Connections is available from the Anaplan XL > Connections ribbon.

One workbook can support multiple connections to different cubes or databases. Whenever Anaplan XL Reporting detects you need to connect to a cube or database, you can select an existing connection or create a new one.

Any connections you have previously made are displayed on the Recent Connections tab for easy access.

To create a new connection, open the Connection Manager from Anaplan XL > Connections and select the New Connection tab. Choose the connection type and provide the appropriate detail.

For cube and dimensional connection types, specify the server or tenant address, and then select the required database and cube.

Anaplan XL Reporting supports a wide variety of data sources, including relational databases and big data providers. For these connection types, you typically only need to specify the server or tenant address, and the database to which you want to connect‌.

In the Manage Connections dialog, right-click a connection and set custom properties. These are applied to the connection string when the connection to the server is opened.

You can also set up the query time-out to prevent long-running queries from causing Excel to hang. This is applied to all grid and formula queries which use the connection.