To determine the detailed information of a particular dataset, you can examine the details of the dataset.
On the main navigation bar, click Data.
The Data view appears, open on the Datasets tab.
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:
This is the qualified name of the data source. Note that it appears in the form DatabaseName.DatabaseTable
.
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.
This is an optional field; you may edit it here.
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:
Note that the Analytical View Builder uses both logical views and tables to define analytical views.
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.
Disabling: choose the Disabled option.
Enabling: choose the Enabled option.
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:
Disabling: choose the Disabled option.
Enabling: choose the Enabled option, and specify the Retention Time, in seconds.
To clear the result cache, click the (clear) icon.
The fetching of incremental results is either disabled (default behavior), or enabled.
Disabling: choose the Disabled option.
Enabling: choose the Enabled option.
The Dataset Detail interface provides information about the creation of the dataset and most recent updates to it: