Dataset Detail

To determine the detailed information of a particular dataset, you can examine the details of the dataset.

  1. On the main navigation bar, click Data.

    Click DATA on main nav

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. Find the dataset in the list of datasets, either by scrolling or by using search.
  3. Click the dataset you want to examine.

    Dataset side navigation appears, open at Dataset Detail view.

Note the following information available on Dataset Detail view, under Detail:

Table

This is the qualified name of the data source. Note that it appears in the form DatabaseName.DatabaseTable.

Data Connection

This is the name of the database that hosts the data. Note that it appears in the form DataConnection.

This feature is ideal for enterprise environments, with dashboards developed on test clusters, and then deployed to a production environment. Note that this assumes that the new connection has, at the minimum, the relevant base tables with metadata definitions that match those on the original connection.

Users with appropriate permissions can switch the data connection of a dataset by following these steps.

  1. Click the (edit/pencil) icon.
  2. Choose a different data connection from the menu.
  3. Click Save.

Description

This is an optional field; you may edit it here.

  1. Click the (edit/pencil) icon.
  2. Enter the descirption in the text box.
  3. Click Save.

Associated Logical View

These are available only on Arcadia connections.

A logical view enables you to model a dataset that is comprised of joined tables. This allows 3rd-party application to access complex datasets in the same manner they can access simple tables.

To create a new logical view and associate it with the dataset, follow these steps:

  1. Click the (edit/pencil) icon.
  2. Select the name of the database in the connection, if you want to change it.
  3. Enter the name of the associated view in the text box.
  4. Click Save.

Note that the Analytical View Builder uses both logical views and tables to define analytical views.

Join Elimination

This is available only on left outer joins. It is turned on by default.

When a visual uses fields and expressions that reference only a subset of the joined tables that form the dataset, this feature eliminates the unnecessary joins and access only the necessary subset of the joined tables. This improves query execution speeds, and renders the visuals faster.

  1. Click the (edit/pencil) icon.
  2. Disabling: choose the Disabled option.

    Enabling: choose the Enabled option.

  3. Click Save.

Result Cache

Each dataset inherits the result caching preferences configured for its connection; the value for this field is From Connection by defaut.

However, this may be changed at the level of the dataset:

  1. Click the (edit/pencil) icon.
  2. Disabling: choose the Disabled option.

    Enabling: choose the Enabled option, and specify the Retention Time, in seconds.

  3. Click Save.

To clear the result cache, click the (clear) icon.

Incremental Results

The fetching of incremental results is either disabled (default behavior), or enabled.

  1. Click the (edit/pencil) icon.
  2. Disabling: choose the Disabled option.

    Enabling: choose the Enabled option.

  3. Click Save.

Information on Creation and Update

The Dataset Detail interface provides information about the creation of the dataset and most recent updates to it:

Created on
This is the date, in timestamp form, when the dataset was created.
Created by
This is the username of the user who created the dataset.
Last updated
This is the date, in timestamp form, of the most recent dataset update.
Last updated by
This is the username of the user who updated the dataset most recently.