Create a Dataset Using Existing Tables

Users can create a dataset by selecting existing tables from the Subject area.

  1. Navigate to Reports and Analytics, Data Visualization.
    Oracle SDM Cloud Analytics opens in a new tab.
  2. If prompted, sign in using the same account credentials as Oracle SDM Cloud.
  3. Click Create and select Dataset.

    Note:

    If the Create button is not visible, the user does not have the appropriate permissions.
  4. Select Local Subject Area.
    This image is an example of the Create Dataset page.
  5. From the left navigation pane, drag and drop the OSDMC_ANALYTICS_SUBJECT_AREA onto the Join Diagram canvas.
  6. Select Edit Definition.
    This image is an example screenshot of the New Dataset page.
  7. Select the tables you want to add and click Add Selected.
    This example shows a dataset being created using existing tables.

    Note:

    To ensure proper data association, Oracle recommends adding the DEVICE_DETAILS table (which includes the DEVICE_NAME column) to all relevant datasets and tables.

    To join the DEVICE_DETAILS table with associated tables, click and hold the Circle icon on the DEVICE_DETAILS table, then drag and drop it onto the desired tables.

  8. Select the Data Access type from the drop-down to specify the caching options for data in this Dataset.
  9. Optionally, preview the data present by clicking Get Preview Data.
  10. Enter a Table Name and click OK.
  11. Repeat steps 5-10 to add all required tables.
  12. Click Save and enter a Dataset Name when prompted.
    This dataset is now available and can be used to create visualizations in within workbooks.