Visualizing Data in Oracle Analytics Server Visualize Data Connect to Your Data Using Datasets 3 Connect to Your Data Using Datasets This topic describes how to use a data source connection to create a dataset. Topics What Are Datasets? About Opening Datasets View Available Connections Data Sources Available for Use in Datasets About the Dataset Editor Add or Update a Dataset's Permissions Create a Dataset From a Connection Add Multiple Connections to a Dataset Add a File to a Dataset Created From a Connection Add a Table to a Dataset Using a SQL Statement Understand Dataset Table Joins Add Joins Between Dataset Tables Disable Auto Joins in Datasets Modify or Fix Joins in a Dataset Add Joins When Table Columns Don't Match Delete Joins from a Dataset Include a Dataset Table in Data Source Queries What is Preserve Grain? Specify Which Table Determines Grain Rearrange the Order of a Dataset's Tables What are Quality Insights? Enhance Your Data Using Quality Tiles About Removing or Restoring Dataset Columns Remove or Restore a Dataset Table's Columns Filter a Dataset Table Specify Whether a Dataset Table Is Cached or Live View a Dataset Table's Original Formatting Create Datasets from Files Use a Subject Area as a Dataset Create a Dataset from a Subject Area in Oracle Fusion Cloud Applications Suite Create a Dataset from an Analysis in Oracle Fusion Cloud Applications Suite Create a Dataset from an Essbase Connection