You can determine how a dashboard accesses the data in a specific dataset. The following access modes are available:
Direct Data Access mode: Visualizations in the dashboard that contain data from the dataset are treated as if they are reports running directly against the data source. Dragging and dropping dataset objects onto visualizations using Direct Data Access mode may be slower than when using In-Memory mode, as dataset results must be retrieved before they can be displayed.
In-Memory mode: Dataset results are retrieved from the data source and stored in memory. Visualizations in the dashboard that contain data from the dataset display subsets of these stored results, which may increase the speed with which data is displayed.
Certain data sources support only Direct Data Access mode or In-Memory mode. To be able to determine the access mode for a dataset, the data source that provides data for the dataset must support both modes.
If the dataset contains data from a data source that only supports Direct Data Access mode, the dataset only supports Direct Data Access mode.
If the dataset contains data from a data source that only supports In-Memory mode, the dataset only supports In-Memory mode.
The table below contains a list of data source types organized by the access modes they support.
| Direct Data Access Mode Only | In-Memory Mode Only | |||
|---|---|---|---|---|
|
|
Reports, including stand-alone reports and reports created within Visual Insight
All other data sources
You have already created a dashboard that contains the dataset to modify.
The dataset must be of a type that supports both Direct Data Access and In-Memory mode.
To define the access mode for a dataset:
From the Datasets panel, hover the cursor over the name of the dataset and click the arrow icon in the top right.
From the menu, point to Data Access Mode, then select one of the following:
To have the dashboard store dataset results in memory and display data based on the stored results, select In-Memory.
To have the dataset directly access data from its data source, select Direct. A confirmation is displayed. Do one of the following:
To have the dataset access data in Direct Data Access mode without keeping a copy of the dataset, select Delete Dataset.
To have the dataset access data in Direct Data Access mode, while keeping a copy of the in-memory dataset, select Keep Dataset.
About datasets in Visual Insight
Adding, replacing, and removing datasets from a dashboard
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices