| Oracle® Health Sciences Data Management Workbench User's Guide Release 2.4 E52292-02 |
|
|
PDF · Mobi · ePub |
Home > User's Guide > Using the Home Page
| Oracle® Health Sciences Data Management Workbench User's Guide Release 2.4 E52292-02 |
|
|
PDF · Mobi · ePub |
Home > User's Guide > Using the Home Page
This section covers the Home page and ways to change the columns and records displayed in many pages of the user interface.
You must first select a study in the Home page before you can work in it in Oracle Health Sciences Data Management Workbench (Oracle DMW).
Select a study from the Studies list and then click the link to the page you want to work in.
Or, if the list is too long:
In field above the list, type all or part of the name of the study.
Press Enter.
Select the study you want in the list. The system displays links to all the user interface pages you can access.
Note:
The next time you log in, the system loads the last study you were working in. To change to a different study, delete the study name in the field above the list and type all or part of the name of the study you want to work in.You must select a study lifecycle mode before you can work in a study. You may have security privileges for only one or two modes of the three:
Development is for studies being set up and modified.
Quality Control is for studies being tested.
Production is for live studies and also for viewing completed studies.
In the Home page, Data Loads tab, you can view information on past data loads for the selected study. You can query on most columns to filter the data loads displayed; see "Querying By Example". Columns include:
Data Model: The Input clinical data model that is the target of the load.
Type:
FILEWATCHER for data loaded from a file by File Watcher.
INFORM for data loaded from Oracle Health Sciences InForm.
File Name/InForm Load Process: The system displays different information depending on the data load type:
For files, the full path of the file loaded.
For InForm, the type of data load: INFORM_DEFINITION, INFORM_METADATA, INFORM_MANUAL_DATA or INFORM_SCHEDULED_DATA.
Last Job: For InForm, the job ID of the most recent load for the clinical data model. For File Watcher, the jobId for the most recent data load from the specified file and clinical data model.
Last Load: For InForm, the date and time of the most recent load for the clinical data model. For File Watcher, the date and time for the most recent data load from the specified file and clinical data model.
Last Load Results: Success, Warnings, or Failure for completed jobs. Click the icon to view or download the log file generated by Oracle DMW.
There are other statuses for incomplete jobs; see "Statuses for Uncompleted Jobs".
View Output (File loads only): Click the icon to view or download the Oracle SQL Loader log file.
View Error Report (File loads only): Click the icon to view or download the error file, if any.
See "Changing the User Interface Display" and "Querying By Example".
You set up data loading when you define input clinical data models. See "Configuring the Oracle Health Sciences InForm Connector" and "Configuring File Watcher" for more information.
The system uses the following statuses in addition to Success, Warnings, and Failure for completed jobs:
Pending: The job has not yet started running.
Started: The job has begun pre-processing.
Executing: The Program has connected to the database and is running.
Finalizing: The job has begun post-processing.
Aborted: The job has been manually stopped while underway.
On Hold: The job is waiting for the quiesce process to complete.
Expired: The system removed the job from the queue after the timeout interval passed.
Duplicate: The job is a duplicate of another job; the currency of the source data, parameter values, and executable instance version are the same. Therefore the system does not rerun the job unless the person submitting the job chooses to force reexecution. To view the job that this one would duplicate, paste the Duplicate Job ID in the search window and locate the job.
This section contains the following topics:
Transformations are displayed by the name of their target data model. The upper pane lists each transformation once and displays information about it and the most recent execution and installation of it.
View Table Transformations Click a transformation's triangular node to see all the target tables and information on the most recent execution of the transformation of the specific table.
View Run History Select a transformation in the upper pane to see information on all past executions in the Run History pane.
View Log Files The following columns are for different types of jobs. Click the icon to view the log file.
Log: The most recent manually submitted job.
Triggered Job Log: The most recent triggered job.
Install Job Log: The most recent installation of the transformation.
You can run transformations manually on the Home page. If they are set up to support it, they can be triggered by a job that writes data to any of their source tables.
To run a transformation:
Select the transformation you want to run and click the Submit Job icon.
The Submit Job icon does not appear if:
You have not selected a transformation.
The selected transformation has not been installed; check the Install Status column.
Enter values in the following fields:
Submission Mode: Select one:
Full mode normally takes longer and includes data deletion. Use Full mode only if you are confident that you are reloading all current data.
Incremental normally is faster and does not include data deletion.
If you are submitting a transformation for a single table and the table is defined with Unit of Work processing, you can also select:
Full UOW mode normally takes longer and includes data deletion.
Incremental UOW normally is faster and does not include data deletion
Note:
You may want to set up regular Incremental loads at frequent intervals and do Full loads at longer intervals. See "Data Processing Types and Modes" for more information.Force Execution: Before running a job, the system checks the source data currency, parameter values, and the version number of the programs. If none of these has changed since the last run, the results would be unchanged if the job ran again, so the system does not execute the job and returns a status of Success.
To run the job anyway, select Force Execution. The system then uses Full mode, regardless of the Submission Mode setting.
Submission Type: Select:
Immediate to run the job once, as soon as possible
Scheduled to set up a regular schedule
Deferred to run the job once, at a future time
Frequency: If you selected Scheduled, enter a number of minutes, hours, or days that you want to elapse between runs, and select the time unit.
Start and End Date:
If you selected Scheduled, select a date and time to begin running on schedule and a date and time to stop.
If you selected Deferred, select a date and time to run the job.
Trigger Downstream Transformations and Validation Checks: Select to make this job trigger validation checks in the target model and transformations from the target model to all others that come after it, in sequence. This can happen only if the source models in the affected transformations are set up to trigger downstream processes; see "Creating Model Mappings".
If you are setting up regularly scheduled runs, this setting applies to each job.
Click the Refresh icon at any time for an update.
The Validation Checks tab displays validation check batches for the selected clinical data model.
When you select a batch, the system displays all its validation checks in the Validate Checks pane and information on all its past executions in the Run History pane.
To submit a batch, select it and click Submit.
The Submit button does not appear if:
You have not selected a validation check batch.
The selected batch has not been installed; check the Installed column.
You must run validation checks as a batch. It is possible to disable a validation check in the Study Configuration page so that it is not included in the batch execution. To find out if a check was included in the batch, check the log file in the Run History pane.
To run a validation check batch:
Enter values in the following fields:
Submission Mode: Select one:
Full mode takes longer and includes data deletion.
Incremental is faster and does not include data deletion.
Force Execution: Before running a job, the system checks the source data currency, parameter values, and version number of the transformation or validation check programs. If Force Execution is not selected and none of these has changed since the last run, the system does not execute the job.
To run the job anyway, select Force Execution.
Submission Type: Select Immediate to execute the job once, as soon as possible. Select Scheduled to set up a regular schedule.
Frequency: If you selected Scheduled, enter a number of minutes, hours, or days that you want to elapse between runs, and select the time unit.
Start and End Date: If you selected Scheduled, select a date and time to begin execution and a date and time to end execution.
Trigger Downstream Transformations and Validation Checks: Select this check box if you want the system to detect all transformations and validation checks set up for this data model and all others that come after it, and submit them sequentially.
Click the Refresh icon at any time for an update.
To check the log file, click the Log icon in the Run History pane.
If the File Watcher service detects a file in a watched location that cannot be loaded because no current, running File Specification for any clinical data model in the study matches it, it displays information about the file on the Files Not Processed tab of the Home page for the selected study.
Files may not be loadable because:
They are misnamed. Note that all letters must be in the same case.
There is a mistake in the File Specification regular expression; see "Creating File Specifications".
There is a matching File Specification, but its end date has passed.
There is a matching File Specification, but it is suspended.
There is a matching File Specification, but the data model is not installed.
The Files Not Processed screen displays the following information about each unloadable file:
File Name
Path: Full path to the file on the file system
Status: The possible statuses are:
DETECTED: The file has been detected in the watched folder but has not yet been submitted.
MISSING: The file was detected but deleted before the scheduled deletion or archive date.
DELETED: The file was deleted by File Watcher as scheduled.
ARCHIVED: The file was archived by File Watcher as scheduled.
File Type: Text or SAS.
File Modified: The modification date of the file on the file system.
Detection Date: The date and time the file was detected, using the date and time in the Oracle DMW database.
Archive Date displays the scheduled archive date before the file is archived and the actual archive date afterward.
Deletion Date displays the scheduled deletion date before the file is deleted and the actual deletion date afterward.
Date Missing: If the file is overwritten or removed from the file system before it is archived or deleted, then the Date Missing is store here.
File Error: Information about the problem. For example, if the file matches a current File Specification but the clinical data model has not been installed, an error appears stating that the model needs to be installed.
Many pages in the user interface that are laid out like tables with columns and rows allow you to change the data display in several ways.
You can sort on values in a single column or up to three columns.
Note:
The system sorts only the records that are currently displayed. For example, if there are a total of 200 rows but the page shows only 50 at a time, when you sort by column value, only the 50 currently displayed rows are sorted. To be sure you have seen all the rows, you must view and sort all four pages in this example.You can click the up and down arrows on the right side of any column heading to sort on that column. You may need to widen the column to see the arrows.
To sort on up to three column values:
Select View, and then select Advanced Sort.
In the Sort By field, select the primary column to sort on and then select either:
Ascending to sort in alphabetical or numeric order (a...z or 0...9).
Descending to sort in reverse alphabetical or numeric order (z...a or 9...0).
In the first Then By field, select the secondary column to sort on and either Ascending or Descending. Within the sort order you specified in Step 1, the system sorts records in the order you specify here.
In the second Then By field, select the tertiary column to sort on and either Ascending or Descending. Within the sort order you specified in Steps 1 and 2, the system sorts records in the order you specify here.
Click OK.
To hide columns:
Select View, and then select Columns. The system displays all available columns, with a check next to those that are currently displayed. To add or hide a single column, click the column name in the list.
To show or hide more columns, select Show More Columns.
Use the arrows to move columns from the Hidden Columns area to the Visible Columns area or the reverse. You can also reorder columns here.
Click OK.
To make it easier to see the columns you need most without scrolling or put the columns you need in a more logical order:
Select View, and then select Reorder Columns.
Use the arrows to move columns up or down in relation to each other. Columns at the top of the list are displayed leftmost on the page.
Click OK.
Alternatively, you can drag and drop columns directly on the page using the mouse.
In many pages that are laid out like tables with columns and rows you can filter the rows displayed:
If empty fields above each column are not already displayed, click the Query By Example icon.
The system displays an empty field above each column heading.
Enter a value in one or more fields above a column heading. Use the wildcard % before and after a string to return all values containing the string in that column. Values are case-sensitive.
Press Enter. The system displays only rows that have the specified value or values.
To show all rows again, click the Clear Filters icon.
You can hide the empty fields by clicking the Query By Example icon again.
Click the Help icon to see online help. Help icons that appear next to a specific field display help just for that field. Help icons that appear at the top of a tab, page, or window display help for that tab, page, or window that usually includes a description of each field.
The first time you open a help window in a session may take a long time. However, if you leave the window open, the next time you click a Help icon, the display is much faster.
To change the password you use to log in to Oracle DMW:
Log in to Oracle Life Sciences Data Hub using the URL provided by your administrator and your Oracle DMW password.
Click the Preferences link in the upper right corner of the My Home screen.
Click the Change Password link.
Enter:
Known As: Enter your name as you would like it to appear in the welcome banner onscreen.
Old Password: Enter your current password.
Password: Enter your new password.
Repeat Password: Enter your new password again.
Click Apply.
Old Password Enter your current password.
|
 Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|