Create a Dataset Using a Custom Table

If you do not select an existing table from the Subject area, you can create a custom table by selecting specific columns.

  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.

    Note:

    Only users belonging to the ServiceUser IDCS application role have permission to create new datasets.
  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 columns to add from the existing tables and click Add Selected.
    For example, in the below example, the user has the following columns selected:
    • TRUSTED_MINOR_COUNTER_SUM
    • TRUSTED_MINOR_COUNTER_MAX
    • TRUSTED_MINOR_COUNTER_MIN
    • TRUSTED_MINOR_COUNTER_AVERAGE
    • DEVICE_NAME
    This example shows a dataset being created by creating a custom table.

    Note:

    • Do not add columns from multiple source tables into a single dataset table, as this may result in misleading or invalid visualizations and data.
    • To ensure device specific data while generating visualizations, Oracle recommends adding the DEVICE_NAME column to all 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.