Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Visual Analytics Workbooks use a snapshot from a specific time of the data and query when a connection to a Data Source is made. If you launched Visual Analytics from a Grid Results in Aqua Data Studio's Query Analyzer, your fields and data reflect what existed at the moment the query finished executing. When the data in a Data Source has been modified, or its Dimensions and Measures no longer exist, Visual Analytics won't incorporate those changes in the view until the data is refreshed. If you want to automatically refresh your data at a set interval, you can use [Data > Auto Refresh...].

Info

Only the data, and not the query, get refreshed upon a Refresh. The query inside Visual Analytics does not get updated from the Query Analyzer when you click Refresh inside Visual Analytics. If you must alter your query, use [Edit Query...] from the Data Source right click menu.

...

When your Refresh completes you will be notified if any fields have been removed by a change in either the font color of the field in the Data Pane, or a change in the field's background color if it is in use in a deck. If required, remove any no longer existent fields from the decks in your Worksheet to repopulate the view and continue your work.

Info

See Error Conditions and How to Resolve Them for for more about what happens when Dimensions or Measures you were using have been dropped from your Data Source since your last refresh.

Anchor
Auto Refresh
Auto Refresh
Auto Refresh

If you want to have your workbook refresh its data automatically every N number of seconds, minutes or hours, you can use the [Data > Auto Refresh...] menu.

...