Select a dataset to work with

As an Oracle Clinical One Platform user, your data is available in Oracle Clinical One Analytics through predefined datasets of local subject area type. Choose one or more datasets to visualize related data.

The reason we have these different datasets is because each allows you to look through the changes based on a specific topic. Select the datasets that are relevant to your work and add them to your workbook to begin visualizing and analyzing data.
Once you selected a dataset to work with, make sure you have the appropriate access. For more information see About your access to Oracle Clinical One Analytics.

Want to see how to perform this task? Watch the video below.

  1. Review the purpose of each dataset and select the most relevant to your work.
    Dataset Description
    Blinded Kits dataset Use it to analyze and visualize data and the audit history of specific kits in the study, from management and dispensation, without viewing details that could potentially unblind users.
    Blinded Subject Events Dataset Use it to analyze and visualize data and audit history of events associated to individual subjects, without viewing details that could potentially unblind users.
    Dh Metrics dataset Use it to analyze when data was last refreshed in Oracle Clinical One Analytics and to monitor data reliability.
    Kits and Randomization Design Dataset Use it to analyze and visualize data regarding the metadata of kit definition, dispensation schedule and randomization definition for the study.
    Queries Dataset Use it to analyze and visualize details and audit history of query data.
    Study Codelist dataset Use it to analyze and visualize data regarding codelists at both study and global level, as well as current code configurations and changes made over time.
    Study Design Dataset Use it to analyze and visualize data regarding the metadata of visits, forms and items included in study versions and applied across study modes.
    Subject Dataset Use it to analyze and visualize subject level details and the audit history of a subject's data.
    Subject Forms Dataset Use it to analyze and visualize data and autdit history of forms associated to individual subjects.
    Subject Form Items Dataset Use it to analyze and visualize item-level data and the audit history of data entered for a question in a form for individual subjects.
    Unblinded Kits Dataset Use it to analyze and visualize data and the audit history of specific kits in the study, from management and dispensation. This dataset includes information that could potentially unblind a user.
    Unblinded Subject Events Dataset Use it to analyze and visualize data and audit history of events associated to individual subjects. This dataset includes information that could potentially unblind a user.

    Tip:

    Browse Dataset descriptions if more details are needed.
  2. Create a workbook in any of the the two options available:
    • From the top menu bar.
    • Starting from a dataset.
  3. Add a dataset to your workbook:

    Tip:

    Even if you already added a dataset as part of the previous step, you can add as many datasets as you need and you can do it at any time while working on your workbook.
    Option Steps
    From the Data Panel at the right of the screen
    1. Make sure the Data tab (Data tab in the Data Panel) is selected in the Data Panel.
    2. Click on the plus icon (Plus (+) icon in data panel) next to the search bar.
    3. Select Add Dataset....
    4. In the Add Dataset dialog, navigate to the Subject Areas tab.
    5. Select a dataset to add and click Add to Workbook.
    From the Prepare pane:
    1. Click Prepare in the top menu bar.
    2. Click the plus icon (+) to add a dataset.
    3. In the Add Dataset dialog, navigate to the Subject Areas tab.
    4. Select a dataset to add and click Add to Workbook.