Follow

How to Change Your Astute BI Data Cube Connection

Click to find the instructions you need for managing your connection to the Astute BI Data Cube:

 

How to Connect to the Astute BI Data Cube Using an Existing Connection
Use the following steps to create a new PivotTable linked to the Astute BI Data Cube by an existing connection. It’s not necessary to create a new connection each time that you use the cube as this information is stored in the My Data Sources folder of a computer.

  1. Go to Insert
  2. Select PivotTable
  3. Select Use an Existing Source
  4. Select Choose Connection
  5. Select the connection that you would like to use.
  6. Click on Open
  7. Click on OK

 

How to Change Astute BI Data Cube Connections in an Existing PivotTable
Use the following instructions to change an existing pivot table to a different existing Data Cube connection.

  1. Click on the existing PivotTable
  2. Go to PivotTable Tools tab
  3. Select Analyze tab
  4. Select Change Data Source
  5. Click on Change Data Source
  6. Select Use an Existing Source
  7. Click on Choose Connection
  8. Select the connection that you would like to use.
  9. Click on Open
  10. Click on OK

 

How to Remove Astute BI Data Cube Connections from a Document
Use the following steps when you would like to sever the link between a document & the Astute BI Data Cube (e.g. when sending a report to the client who shouldn’t have access to the Cube). Please note that it’s not possible to reconnect a PivotTable to the Data Cube if the connection is removed.

  1. Click on Data Tab
  2. Click on Connections
  3. Highlight connections to be removed
  4. Click Remove button
  5. Click on Ok
  6. Click on Close

 

How to Remove Astute BI Data Cube Connections from a Computer
Use the following steps to remove connections form a computer.

  1. Click on the Windows Start button
  2. Search for My Data Sources
  3. Delete cube connections as required

 

Return to Top

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk