1. Using Oracle Fusion Analytics Warehouse
  2. Work with Data
  3. Manage Data
  4. Manage Data Sets

Manage Data Sets

You can update and delete the data that you added from various data sources.

You can use the Data Sets page to examine data set properties, access permissions, and free up space by deleting data sets that you no longer need.
  1. Go to the Data page, then Data Sets section.
  2. Click the Actions menu of a data set or right-click the data set that you want to manage, and click Inspect.
  3. Optionally, use the Inspect option to review data set columns and change the data set properties. For example, you can change the Name and Description.
  4. Optionally, use the Inspect option to change whether to treat data set columns as measures or attributes.
    You can't change how a column is treated if it’s already matched to a measure or attribute in the data model.
  5. Optionally, use the Inspect option to specify the access permissions that users and roles have for the data.
    You’re allowed to set permissions on some data sources, such as uploaded data sets. See Control Share of Data You Added.
  6. Optionally, use the Inspect option to change the Data Access for a database table. The default is Live because database tables are typically large and shouldn’t be copied to cache. If your table is small, then select Automatic Caching and the data is copied into the cache if possible. If you select Auto, then you have to refresh the data when it’s stale.
  7. Optionally, download a data set created from a Microsoft Excel file by right-clicking the data set and selecting Download File. Note that the columns in the download match the columns in the file that you originally uploaded. Any derived columns that you added in the Visualize editor’s Prepare canvas aren’t included in the data set download.
  8. Optionally, update data for a data set created from a Microsoft Excel file or Oracle Applications by right-clicking the data set and selecting Reload Data.
If you have Full Control permissions, you can grant permissions to others and delete uploaded data sets, but be careful not to delete a data file that is still a data source for projects. See Delete Data that You Added.