Reload a Dataset's Data
Keep your analytics content up-to-date by reloading dataset data when it's been updated.
About Reloading a Dataset's Data
You can reload a dataset that uses a single file as its source, when one or more tables in the dataset are cached, or when the dataset is created from running a data flow. Or you can reload a datasets's files and tables individually.
Reloading data ensures that workbooks and visualizations contain current data. The most current data is displayed in workbooks and visualizations after the dataset reload is complete and you refresh the workbooks. See Refresh a Workbook's Data.
How you reload data depends on the dataset's data source type.
Data from External Connections
When you reload data for a dataset with an external connection, the dataset's SQL statement is rerun and the current data for the tables with the Data Access field set to Automatic Caching is loaded into cache.
If your dataset contains one or more tables with the Data Access field set to Automatic Caching, then you can use the Data page to reload the tables in the dataset. To reload individual tables, use the Dataset editor. You can also set up a schedule to reload your dataset's tables as often as once per hour. See Schedule a Dataset Reload.
Reload Excel, CSV, or TXT File
When you reload a Microsoft Excel file (XLSX or XLS), you must ensure that the newer spreadsheet file contains a sheet with the same name as the original file. And the sheet must contain the same columns that are in the dataset. The data reload fails if the file you load is missing columns.
When you reload a CSV or TXT file, make sure that it contains the same columns that are in the dataset. A reload will fail if the file you load is missing columns.
Scheduling a reload isn't available for datasets that contain only Excel, CSV, or TXT files.
To reload a dataset that uses one file as its source, use the Data page or Dataset editor. If a dataset uses two or more files, then use the Dataset editor to manually reload each file. If a dataset uses a combination of files and external connections, then use the Dataset editor to manually reload each file.
Oracle Fusion Cloud Applications Suite
You can reload data and metadata for Fusion Applications Suite data sources. If the Fusion Applications Suite data source uses logical SQL, reloading data reruns the dataset's SQL statement.
Reload Data from the Workbook Editor
When you're editing a workbook, you can reload data to update the workbook with the most up-to-data data.
- On the Home page, locate the workbook and click Open.
- Click the Visualize tab.
- On the Data panel, right-click the table name and select Reload Data.
Reload an Individual Table in a Dataset
Use the Dataset editor to reload data for an individual dataset table that uses a connection. Reloading queries the table's data source and loads the current data into cache.
- On the Home page, click Data and then click Data.
- Click the Datasets tab.
- Locate the dataset that contains the table, click Actions, and then click Reload Data.
Reload Tables in a Dataset
Use the Datasets tab to reload data for the dataset's tables that use connections and have the Data Access field set to Automatic Caching. Reloading queries the tables' data sources and loads the current data into cache.
Note:
You can also programmatically reload data for an existing dataset that's based on a connection using the REST API. See Reload data for a dataset in the REST API for Oracle Analytics Cloud.Reloading data ensures that workbooks and visualizations contain current data. The most current data is displayed in workbooks and visualizations after the dataset reload is complete and you refresh the workbooks.
- On the Home page, click Navigator and then click Data.
- Click the Datasets tab.
- Locate the dataset that you want to reload, click
Actions, then click
Reload Data.
- Select the tables that you'd like to reload then click Run Now.
Reload a Dataset's Files
Reload data from the XLSX, XLS, CSV, or TXT files to make sure that you have the most up-to-date workbook content.
Reloading a dataset's files ensures that workbooks and visualizations contain current data. The most current data is displayed in workbooks and visualizations after the file reload is complete and you refresh the workbooks.
- If a dataset contains one table and it uses a file as its source, then use the Data page or Dataset editor to reload the file.
- If a dataset uses two or more files, then use the Dataset editor to reload each file.
- If a dataset uses a combination of files and external connections, then use the Dataset editor to upload each file. See Reload Tables in a Dataset.
- On the Home page, click Navigator and then click Data.
- Click the Datasets tab.
- Locate the dataset that you want to open, click Actions, and then click Reload Data.
- In the Reload Data dialog, drag and drop the
file onto the dialog or click Select File to browse for
the file.
- Click OK.
View a Dataset's Reload History
Historical information is generated for dataset reloads at the job level and at the table level.
- Use only files.
- Use a connection and a file. Oracle Analytics generates historical information only for a dataset's tables that use a connection.
- Use an Oracle EPM Cloud or Oracle Essbase connection.
- On the Home page, click Navigator and then click Data.
- Click the Datasets tab.
- Locate the dataset that you want reload history information for, click Actions, and then click Inspect.
- Click the History tab.
- Click a job in the list to go to the General tab to view its details.
- Optional: Click the Status tab to view table information or to access a list of
all reloaded tables. Click a table to view more reload
information about it.
View or Download a Reload Job's Log Files
Log files are generated for dataset reloads at the job level and at the table level.
- Use only files.
- Use a connection and a file. Oracle Analytics generates log files only for a dataset's tables that use a connection.
- Use an Oracle EPM Cloud or Oracle Essbase connection.
- On the Home Page, click Navigator and then click Data.
- Click the Datasets tab.
- Locate the dataset that you want the reload logs for, click Actions, and then click Inspect.
- Click the History tab.
- Click the job that you want logs for.
- In the General tab, click the , (Job details menu) and select View Log to view the log, or select Download Logs to download the logs.
- Optional: If the job reloaded more than one table and you want to view log information for a specific table, then click Status and in the list locate and click the table's reload task name.
- Optional: Click Job Task Menu and select View Log.