About the Dataset Editor

Use the Dataset editor to create or edit a dataset that includes tables, joins, and enriched data.

When you create a dataset from a connection that supports datasets with multiple tables, Oracle Analytics displays the Dataset editor. See Data Sources Available for Use in Datasets.

You can't create datasets with multiple tables from Oracle EPM Cloud, Oracle Essbase, or Google Analytics connections. Use the Transform editor for connections that don't support datasets with multiple tables.

Each Dataset editor feature and what you can do with it is explained here:

Description of the illustration data_set_editor_insights_02.jpg

• Connections Pane

  This pane displays the data source connection's schemas and tables, and uploaded files. To add a table or file from the Connections Pane to the Join Diagram, drag and drop it from the list to the diagram or double-click it. You can add more than one table or file.

  Click Add to open the Add Connection or Open File dialog where you can select or create another connection or select a file to add to the dataset.

  Use Search to find a schema, table, or file displayed in the Connections pane.

  To write a SQL statement to create a table, drag and drop the Manual Query item to the diagram. Then go to the diagram and double-click the Manual Query table to access the SQL editor.

  Note:

  Use Manual Query when a JDBC connection doesn't provide a schema and tables listing.
  
  
  
  Description of the illustration data_set_editor_connection_pane.png
  
  

• Join Diagram

  The Join Diagram displays all of the tables and joins in the dataset. Drag and drop tables to reorder them in the diagram.

  When you select a table, the Preview Data area displays a sample of the table's data. If you double-click a table, then the Transform editor is displayed where you transform or enrich the table's data.

  The diagram's join links and icons indicate which tables are joined and the type of join used. A join is created when you drag and drop one table onto another. If you click on a join, the Join editor is displayed where you can view, update, or fix it.

  
  
  
  Description of the illustration data_set_editor_join_diagram.jpg
  
  

• Data Preview

  The data preview area displays a data sample for the table selected in the Join Diagram. From the data preview area you can click a column's type attribute to change its type. For example, change the CALENDAR_YEAR column from a measure to an attribute.

  Be default, a quality insight tile is displayed for each column. Quality Insights uses a representative sample of the column's data to determine information about the column's data quality. See What are Quality Insights?

  
  
  
  Description of the illustration data_set_editor_insights_data_preview.jpg
  
  

• Auto Join Tables Toggle Button

  The Auto Join Tables toggle button determines if joins are automatically created when you drag and drop tables onto the Join Diagram. By default Oracle Analytics creates joins, but in some cases you might want to turn off automatic join creation and manually create table joins.

  
  
  
  
  

• Dataset Table Page Tabs

  The Dataset editor displays a tab for each table in the dataset. Click a table tab to go to the Transform editor to transform or enrich the table's data. The tabs also display at the bottom of the Transform editor. Use them to navigate to other tables or back to the Join Diagram.

  
  
  
  Description of the illustration data_set_editor_join_diagram_tables_tab.jpg
  
  

• Dataset Editor Toggle Buttons

  These buttons control which parts of the Dataset editor are displayed.

  
  
  

  This button hides or displays the connections panel:

  This button hides or displays the quality tiles:

  This button hides or displays the preview data area: