About the Dataset Editor

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

For information about how to create a dataset, see Typical Workflow to Create a Dataset from a Connection.

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 Containing Multiple Tables.

You can't create datasets with multiple tables from Google Analytics, Dropbox, and Essbase connections. Use the Transform editor with spreadsheets, CSV and text files, and the connections that don't support datasets with multiple tables.
Dataset Editor

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. To add a table 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.

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

    Use Search to find a schema or table 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.


    Connections Pane

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


    Join Diagram and Join Links

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


    Data Preview

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


    Table Page Tabs

  • Dataset Editor Toggle Buttons

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


    Dataset Editor Toggles

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

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

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