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 local subject area or 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:

  • 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.


    Use Manual Query when a JDBC connection doesn't provide a schema and tables listing.

  • 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.

  • 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?

  • 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.

    Auto Join Tables Toggle Button

  • 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.

  • Dataset Editor Toggle Buttons

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

    Dataset Editor Toggles

    This button hides or displays the connections panel: Connections Panel Toggle

    This button hides or displays the quality tiles: Quality Tiles Toggle

    This button hides or displays the preview data area: Preview Data Toggle