Type = How-tos, ; Topic = OPUS Solution Environment, Reports and Dashboards,;Persona = User, Orchestration Architect, Solution Partner, Technology Partner,; Orchestration = Manufacturing, Logistics, Commerce, Transportation, Clinical Supply,; Function = Supply Chain, IT, Operations, Regulatory Affairs, Quality, Commercial, Pharmacy, Project Management, Finance, Procurement, Spare 2,

Manage datasets

Dataset contains the results of a single scheduled report run. After a scheduled report's schedule is activated, OPUS Reports and Dashboards (ORD) generates a new dataset for each scheduled run.

ORD processes datasets asynchronously to support larger report volumes. This processing avoids the execution-time and browser-memory limitations of synchronous reports. Backend processing includes data flattening, column mapping, and result consolidation across multiple process networks.

The dashboard displays datasets based on the following scenarios:

  • Latest dataset successful: The dashboard uses the latest successful dataset for the scheduled report.

  • Latest dataset failed: The dashboard uses the previous successful dataset for the scheduled report.

  • No dataset available: If no dataset is available, the dashboard displays the message "Latest dataset is not available."

Users can edit a scheduled report to update its execution schedule.

Each dataset contains fixed results from a scheduled run. Dashboard filters and application network selections do not affect the dataset's contents.

To view datasets associated with a Scheduled Report:

  1. Select the Main Menu icon.

  2. Select Reports and Dashboards.

  3. Select Datasets in the side menu.
  4. Select the Company catalog from the Datasets drop-down. The list of datasets appears.
  5. Click a dataset link to open the Datasets page.

  6. If the dataset status is Completed, the dataset results appear in the table.

If the dataset contains no records, the table displays No Rows To Show.

To view previously generated datasets for a Scheduled Report:

  1. Select the Main Menu icon.

  2. Select Reports and Dashboards.

  3. Select Datasets in the side menu.
  4. Select the Company catalog from the Datasets drop-down. The list of datasets appears.
  5. Click a dataset link to open the Datasets page.

  6. Click Historical Datasets. The Historical Datasets push panel appears.

  7. Select any previous dataset from the Datasets drop-down list.

  8. Click Apply.

    The user is navigated to the selected dataset in the new tab.

    If the Scheduled Report has only one dataset, the Historical Datasets option is disabled.

  1. Select the Main Menu icon.

  2. Select Reports and Dashboards.

  3. Select Datasets in the side menu.
  4. Select the Company catalog from the Datasets drop-down.
  5. A list of datasets appears.
  6. In the Filters push panel, fill in the following fields:

    • Status field – Enter status of the dataset.

    • Dataset Name field – Enter the dataset name.

    • Scheduled Report Name field – Enter the scheduled report name.

  7. Select Apply.

    The filter shows the required dataset.

Tag end