Creating R Data Sets


Use data sets to collect the information that you will use to build charts, tables, and dynamic inputs.

Before You Begin

  • Configure an R server.

  • To create an embedded data set, your CommCell user account requires a role with the following permissions and associations:

    • Add Report permission and an association with the CommCell entity

    • Query Datasource permission and an association with the Data Source entity that you will use

    For more information on users, permissions, and associations, see User Administration and Security - Overview.


  1. On Web Console, click Reports.

    The Reports page appears.

  2. Create a new report, or open an existing report:

    • To create a new report, from the navigation pane, click Configuration > Reports and click New Report.

    • To open an existing report and add a new data set to it, from the navigation pane, click Configuration > Reports, and next to the Report Name under Actions, click Edit.

  3. On the Report Builder page, in the Report Name box, type a name for the report, and in the Description box, type a short description of the report.

  4. On the Data Sets tab, click Add .

    The Add Data Set dialog box appears.

  5. At the top of the dialog box, from the list, select R Script, and in the Data Set Name box, type a name.

  6. In the Source Data Set box, click and add the data set.

  7. In the Data Set Query box, enter the R script on top of the source dataset to create charts and tables.

    You can refer the data in the source data set in the script using the format dataset$id, where dataset in the source dataset name and id is the column name in the dataset.

    Find below a sample R script for the data set query:

  8. To create plot charts using R, specify the R script in Plot query box.

    Find below a sample R script using ggplot:

    p<-ggplot(data=da, aes(x=x,y=y)) +geom_line()
  9. Click Done.

    The data set you created appears in the Report Builder under Data Sets.