Analytical Views may be monitored and managed through the Arcadia Enterprise interface.
On the main navigation bar, click Data.
The Data view appears, open on the Datasets tab.
Click the Analytical Views tab.
The list of analytical views appears.
This interface provides most of the management functions for analytical views, including the definition of analytical views, which is described in Creating Analytical Views in User Interface.
Note the elements of this interface:
Create Analytical View button.
List of specific analytical views.
Note that the naming convention used here is ConnectionName.TableName|LogicalViewName_av_n
, where n
is the sequential order in which the analytical views are created.
The State of the specific view. Possible values are indicated by up to date (equivalent to FRESH
), invalid, stale, and unusable.
The icon (refresh) is available only when the analytical view is not in the up to date state. Clicking it will refresh the analytical view.
The icon (trash) is available at all times. Clicking it brings up the Delete confirmation modal window to confirm the removal of the analytical view.
N/A
.N/A
.sum(1)
,creating he which is equivalent to simple record count.The column Show/Hide SQL contains the SELECT
statement that defines the specific analytical view.
By default, the statement is hidden. To show it, click Show SQL. To hide it, click Hide SQL.
This column cannot be edited to change the analytical view definition. See Understanding the SQL Expression of the Analytical View.