Oracle® Life Sciences Data Hub Application Developer's Guide Release 2.1.4 Part Number E18306-01 |
|
|
View PDF |
This chapter contains the following sections:
The Oracle Life Sciences Data Hub (Oracle LSH) generates reports on demand that provide an audit trail of the activities performed using Oracle LSH and present information on the state of the system's various components.
You can run a report only if you have security access to the screen from which it is launched and to the meta-data included in the report.
To generate a system report:
In the relevant screen, select Reports from the Actions drop-down and click Go. The system displays the reports that are available in your current context.
Select the report you want and click Generate Report. The system generates the report and then displays it as a PDF document on screen.
This section contains the following reports:
This section contains the following:
The Blinding Rights Report lists each user-defined security role that has blinding-related privileges.
The report includes a section for each of the following:
Read Unblind rights for Table instances
Unblind rights for Table instances
Blind Break rights for Table instances
Read Unblind rights for outputs
Unblind rights for outputs
Blind Break rights for outputs
In each section, the reports displays all roles that have the relevant operation assigned, and which subtype the assignment applies to.
From the Security tab, click the Roles subtab.
Select Reports from the Actions drop-down list.
Click Go.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Operations for a Role Report displays all the operations associated with a user-defined security role in Oracle LSH.
For each operation, the report displays the following information:
Subtype
Object Type
Operation
Timestamp of Assignment of Operation
To generate the Operations for a Role Report, do the following:
From the Security tab, click the Roles subtab.
To list all Roles, click Go in the Search Role section. You can also type in the Role name in the Role field and click Go.
Click the Role name you want to generate this report for.
Select Reports from the Actions drop-down list.
Click Go.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The User Group Assignments Report displays information on every user group assigned to a particular object. You can choose to include only current assignments or all past assignments.
The User Group Assignments Report has two sections:
Header
Group Details
To generate the User Group Assignments Report, do the following:
Select Reports from the Actions drop-down list in the Properties screen of a Domain, Application Area, Work Area, or any object's definition or instance whose user group assignments you want to see.
Click Go.
Select Security Report from the list of reports available for the Domain, Application Area, Work Area, or the object definition or instance.
If you want to include past assignments, select the checkbox Include Groups assigned and removed in the past.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Users in Group Report lists all the users who are members of a selected user group. For each user, the report displays the following information:
Role
Description of Role
User ID
Timestamp of Assignment of User
Timestamp of Removal of User
From the Security tab, click the User Groups subtab.
To list all User Groups, click Go in the Search User Group section. You can also type in the User Group name in the User Group field and click Go.
Click the User Group you want to generate this report for.
Select Reports from the Actions drop-down list.
Click Go.
If you want to Include users added or removed in the past, select the checkbox.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following reports:
This section contains the following:
The Blind Break Report displays information about each time real data has been accessed from Oracle LSH, that is, any of the following situations:
Each time a job has been run against a selected blinded Table instance in Blind Break mode to display the real data
Each time an IDE (integrated development environment such as SAS) has been launched with the Blind Break setting set to Real (Blind Break)
Each time a visualization (through an external tool such as Oracle Business Intelligence Enterprise Edition or Oracle Discoverer) has been launched with the Blind Break setting se to Real (Blind Break)
Each time data has been browsed with the Blind Break setting set to Real (Blind Break)
The Blind Break Report has two sections:
Select Reports from the Actions drop-down list in the Table instance's Properties screen. Click Go.
Select Blindbreak Report from the list of reports available for Table instances.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate browser window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Blinded Table Instances Audit Report displays all Table instances whose blinding flag or blinding status has been changed, in a particular Work Area. For each such Table instance, the report displays each change to the blinding flag or blinding status. For each change, the report displays the following information:
Select Reports from the Actions drop-down list in the Work Area's Properties screen. Click Go.
Select Blinding Table Instances Audit Report from the list of reports available for Work Areas.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate browser window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Blinded Table Instances Report displays details of all Table instances in a Work Area, regardless of their Blinding Status, and displays their Blinding Flag setting and Blinding Status.
The report has the following information for each Table instance:
Domain
Application Area Name
Work Area Name
Table Instance Name
Version
Validation Status
Source Definition Name
Source Definition Version
Created Time Stamp
Blinding Flag
Blinding Status
Select Reports from the Actions drop-down list in the Work Area's Properties screen. Click Go.
Select Blinding Table Instances Report from the list of reports available for Work Areas.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate browser window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Unblinded Outputs Reports displays all jobs run on real, unblinded data in a particular Table instance.
The Unblinded Outputs Report has the following sections:
Header
Job and Output Details
Table Instance Status
See "Header Information for Object Instances" for details on the header section.
The report displays the following details for each job:
Job ID
Job Submission Timestamp
Job Submitted by
Output Name
Output Creation Timestamp
Owning Executable Instance
Executable Type
Executable Validation Status
Table Instance Status at the Time of Submission of Above Jobs
The report displays the following details for the source Table instance at the time of job submission:
Job ID
Validation Status
Blinding Flag
Blinding Status
Select Reports from the Actions drop-down list in the Table instance's Properties screen. Click Go.
Select Unblinding Outputs Report from the list of reports available for Table instances.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate browser window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following reports:
This section contains the following:
The Application Area Library Report displays information on objects contained in a particular Application Area. You can select the types of objects to include in the report.
The report lists objects by object type. For each object, the report displays the following information:
Name
Description
Version
Status
Checked In or Out
Check out by
Validation Status
To generate the Application Area Library Report, do the following:
Select Reports from the Actions drop-down list in the Application Area's Properties screen.
Click Go. The system displays the names of the two reports you can run for an Application Area. Under the Application Library Report the system lists each type of object that is stored in an Application Area Library.
Select Application Library Report.
Select the object types that you want to include in the report.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Domain Library Report displays information on objects contained in a particular Domain. You can select the types of objects to include in the report.
The report lists objects by object type. For each object, the report displays the Domain name and Classification, in addition to the following information:
Name
Description
Version
Status
Checked In or Out
Check out by
Validation Status
To generate the Domain Library Report, do the following:
Select Reports from the Actions drop-down list in the Domain's Properties screen.
Click Go. The system displays the names of the two reports you can run for an Domain. Under the Domain Library Report the system lists each type of object that is stored in an Domain Library.
Select Domain Library Report.
Select the object types that you want to include in the report.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Work Area - All Instances Report contains information on each object instance the selected Work Area contains.
The report displays the following information about the Work Area:
Domain Name
Application Area Name
Work Area Name
Validation Status
Classification
For each instance, the report displays the following information:
Instance Name
Instance Version
Last Modified by
Last Modified TS
Source Definition Name
Source Definition Version
Checked In or Out
Definition's Application Area
Definition's Domain
To generate the Work Area - All Instances Report, do the following:
Select Reports from the Actions drop-down list in the Work Area's Properties screen.
Click Go. The system displays the list of reports available for Work Areas.
Select All Instance Report.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Work Area Cloning Report lists all Work Areas that have been created as clones of the selected Work Area.
The report displays the following information for the selected Work Area:
Domain Name
Application Area Name
Work Area Name
Validation Status
Classification
The report displays the following information for each clone Work Area:
Clone Work Area Name
Description
Status
Validation Status
Usage Intent
Cloned from Work Area Version
Cloned Timestamp
Clone Labels
Cloned by
Version Label
To generate the Work Area Cloning Report, do the following:
Select Reports from the Actions drop-down list in the Work Area's Properties screen.
Click Go. The system displays the list of reports available for Work Areas.
Select Cloning Report.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Work Area Installation History report displays a record of every installation in the selected Work Area.
The report displays the following information about the Work Area:
Domain Name
Application Area Name
Work Area Name
Validation Status
Classification
For each installation, the report displays the following information:
Installation Attempt
Install Status
Install Mode
Force to regenerate scripts
Installed By
Installation Timestamp
To generate the Work Area Installation History Report, do the following:
Select Reports from the Actions drop-down list in the Work Area's Properties screen.
Click Go. The system displays the list of reports available for Work Areas.
Select Installation History.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Work Area Version History report displays a record of every version of the selected Work Area.
The report displays the following information about the Work Area:
Domain Name
Application Area Name
Work Area Name
Validation Status
Classification
For each version, the report displays the following information:
Version
Description
Status
Validation Status
Usage Intent
Version Label
Last Modified Timestamp
Last Modified By
Cloned from Version
To generate the Work Area Version History Report, do the following:
Select Reports from the Actions drop-down list in the Work Area's Properties screen.
Click Go. The system displays the list of reports available for Work Areas.
Select Version History Report
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
Oracle LSH object meta-data reports present an overview of an object's history and current status.
This section contains the following:
This section contains the following:
The All Instances of a Definition Report contains information on all the object instances that are based on the selected definition.
The report displays the following information about the selected object definition:
Domain Name
Application Area Name
For each instance, the report displays the following information:
Name
Description
Latest Version
Creation Time
Created by
Checked in or out?
Last Modified Time
Last Modified by
Validation Status
Classification
The following details are presented:
Instance Name
Instance Version
Last Install Version
Status
Validation Status
Work Area
Application Area
Domain
To generate the All Instances of a Definition Report, do the following:
Select Reports from the Actions drop-down list in the definition's Properties screen.
Click Go.
Select All Instances Report from the list of reports available for object definitions.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
A Data Mart Report contains information about the current status of a single Data Mart definition. This is the same information that is available in the Data Mart's Properties screen and its subtabs. For information on a Data Mart's version history, see "Object Version History Report" .
For information on Data Marts, see Chapter 8, "Defining Data Marts".
The Data Mart Report has the following three sections:
Header
Attributes
Child Objects
See Header Information for Object Definitions for details on the Header section.
The second section displays a table with the values of the attributes Data Mart Type, File Name, File Name Extension, and Mode.
The third section displays tables with information about each of the following Data Mart components:
Note:
These tables display all possible information for each component. Some of the table columns may not be applicable to a particular type of Data Mart or to a particular component.Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, SAS Name, and SAS Library Name.
Note:
All Data Mart Table Descriptors are of type Source, not Target.Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.
Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Primary?, Error if generated?, and Error if not generated?.
To generate the Data Mart Report:
Select Reports from the Actions drop-down list in the Data Mart's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object definitions.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Data Mart Instance Report includes all the definitional information that pertains to the instance, including information about the underlying Data Mart definition. See "Data Mart Report".
This is the same information that is available in the Data Mart instance's Properties screen and its subtabs.
The Data Mart Instance Report has four sections:
Header
Attributes
Child Objects
Mapping Information
See "Header Information for Object Instances" for details on the header section.
The second section displays a table with values of the attributes Data Mart Type, File Name, File Name Extension, and Mode.
The third section displays tables with information about each of the following Data Mart components. The information provided here is the same as that in the Data Mart Report. Additionally, you can see mapping information about Table Descriptors.
Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, SAS Name, and SAS Library Name.
Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.
Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Primary?, Error if generated?, and Error if not generated?.
The last section presents detailed mapping information for the Data Mart instance. This section has two subsections.
The first subsection displays the following information:
TD Table Definition Name
Description
Latest Version
Checked In or Out
Checked out by
Last Modified Time
Last Modified by
Validation Status
The second subsection displays details about the tables that the Table Descriptors are mapped to. This table has two parts, one for the Table Descriptor and the other for the Table instance.
Table Descriptor
Column Name
Data Type
Table Instance
Column Name
Format String
Default Value
Data Type
Mapping Status
To generate the Data Mart Instance Report:
Select Reports from the Actions drop-down list in the Data Mart instance's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object instances.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
A Load Set Report contains information about the current status of a single Load Set definition. This is the same information that is available in the Load Set's Properties screen and its subtabs. For information on a Load Set's version history, see "Object Version History Report" .
For information on Load Sets, see Chapter 7, "Defining Load Sets"
The Load Set Report has the following three sections:
Header
Attributes
Child Objects
See Header Information for Object Definitions for details on the Header section.
The second section displays the values of the attributes Adapter Type, Remote Location Name, Database Schema, Study Name, View Type, Design Sub-System, and Yes or No settings for Save to File/Save Input File?.
The third section displays tables with information about each of the following Load Set components:
Note:
These tables display all possible information for each component. Some of the table columns may not be applicable to a particular type of Load Set or to a particular component.Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, and SAS Name.
Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.
To generate the Load Set Report, do the following:
Select Reports from the Actions drop-down list in the Load Set's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object definitions.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Load Set Instance Report includes all the definitional information that pertains to the instance, including information about the underlying Load Set definition. See "Load Set Report".
This is the same information that is available in the Load Set instance's Properties screen and its subtabs.
The Load Set Instance Report has four sections:
Header
Attributes
Child Objects
Mapping Information
See "Header Information for Object Instances" for details on the header section.
The second section displays a table with values of the attributes Adapter Type, Remote Location Name, Database Schema, Study Name, View Type, Design Sub-System, and Yes or No settings for Save to File/Save Input File?.
The third section displays tables with information about each of the following Load Set components. The information provided here is the same as that in the Load Set Report. Additionally, you can see mapping information about Table Descriptors.
Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, SAS Name, and SAS Library Name.
Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.
The last section presents mapping information for the Load Set instance. This section has two subsections.
The first subsection displays the following information:
TD Table Definition Name
Description
Latest Version
Checked In or Out
Checked out by
Last Modified Time
Last Modified by
Validation Status
The second subsection displays details about the tables that the Table Descriptors are mapped to. This table has two parts, one for the Table Descriptor and the other for the Table instance.
Table Descriptor
Column Name
Data Type
Table Instance
Column Name
Format String
Default Value
Data Type
Mapping Status
To generate the Load Set Instance Report:
Select Reports from the Actions drop-down list in the Load Set instance's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object instances.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
The Object Validation Report displays information about the validation life cycle of a selected object instance. The report displays changes to the object instance's validation status and lists all supporting documents and supporting outputs associated with the object instance.
The report has the following sections:
Header
Validation Status
Supporting Document
Supporting Output
See "Header Information for Object Instances" for details on the header section.
For each change in validation cycle, the report displays the following information:
Validation Status
Status Update Timestamp
Updated by
Comments
For each supporting document, the report displays the following information:
Name
File Name
Description
Version
Uploaded by
Status
Validation Status at time of Upload
For each supporting output, the report displays the following information:
Output Name
Job ID
Description
Added by
Status
Validation Status at time of adding
Select Reports from the Actions drop-down list in the Properties screen of any object instance. Click Go.
Select Validation Report from the list of reports.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate browser window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Object Version History Report displays a record of every version of the selected object definition.
The Object Version History Report has two sections.
Header
Version History
See Header Information for Object Definitions for details on the Header section.
The second section displays the following details about the object:
Version
Description
Status
Validation Status
Copied from Version
Version Label
Last Modified Timestamp
Last Modified by
Check in/Check out comments, if any
To generate the Object Version History Report, do the following:
Select Reports from the Actions drop-down list in the definition's Properties screen.
Click Go.
Select Version History Report from the list of reports available for definitions.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
A Program Report contains information about the current status of a single Program definition. This is the same information that is present in the Program's Properties screen and its subtabs. For information on a Program's version history, see "Object Version History Report".
For information on Programs, see Chapter 5, "Defining Programs".
The Program Report has the following three sections:
Header
Attributes
Child Objects
See Header Information for Object Definitions for details on the Header section.
The second section displays a table with the value of the attribute Program Type.
The third section displays tables with information about each of the following Program components:
Note:
These tables display all possible information for each component. Some of the table columns may not be applicable to a particular type of Program or to a particular component.Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, and SAS Name.
Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.
Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Primary?, Error if generated?, and Error if not generated?.
Source Code. For each Source Code, the report displays the Source Code Name, Description, Yes or No settings for Primary?, Share Type, File Type, Yes or No settings for Sharable?, File Name, Source Code Shared From?, and the actual source code.
To generate the Program Report:
Select Reports from the Actions drop-down list in the Program's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object definitions.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Program Instance Report includes all the definitional information that pertains to the instance, including information about the underlying Program definition. See "Program Report".
This is the same information that is available in the Program instance's Properties screen and its subtabs.
The Program Instance Report has four sections:
Header
Attributes
Child Objects
Mapping Information
See "Header Information for Object Instances" for details on the header section.
The second section displays a table with the value of the attribute Program Type.
The third section displays tables with information about each of the following Program components. The information provided here is the same as that in the Program Report. Additionally, you can see mapping information about Table Descriptors.
Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, SAS Name, and SAS Library Name.
Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.
Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Primary?, Error if generated?, and Error if not generated?.
Source Code. For each Source Code, the report displays the Description, Yes or No settings for Primary?, Share Type, File Type, Sharable?, File Name, Source Code Shared From?, and the actual source code.
The last section presents mapping information for the Program instance. It has two subsections.
The first subsection displays the following information:
TD Table Definition Name
Description
Latest Version
Checked In or Out
Checked out by
Last Modified Time
Last Modified by
Validation Status
The second subsection displays details about the tables that the Table Descriptors are mapped to. This table has two parts, one for the Table Descriptor and the other for the Table instance.
Table Descriptor
Column Name
Data Type
Table Instance
Column Name
Format String
Default Value
Data Type
Mapping Status
To generate the Program Instance Report:
Select Reports from the Actions drop-down list in the Program instance's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object instances.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Report Set Report contains information about the current status of a single Report Set. This is the same information that is available in the Report Set's Properties screen and its subtabs. You can choose whether or not to include information on Post-Processing and Overlay Template Parameters for the Report Set and each Report Set Entry.
For information on a Report Set's version history, see "Object Version History Report".
For more information on Report Sets, see Chapter 9, "Defining Report Sets".
The Report Set Report has the following three sections:
Header
Attributes
Child Objects
See Header Information for Object Definitions for details on the Header section.
The second section displays the values of the attributes Title, Yes or No settings for Strict Numbering?, and Yes or No settings for Unique Numbering?.
If you have selected Post-Processing Parameters or Overlay Template Parameters, the report displays these at the Report Set level as well as for each Report Set Entry (see below).
Planned Output. For each Planned Output, the report displays Name, File Name, Yes or No settings for Primary?, Yes or No settings for Error if generated?, and Error if not generated?.
Post-Processing. For Post-processing, the report displays Parameter, Yes or No settings for Default?, Yes or No settings for Value Propagation?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Overlay Templates. For each Overlay Template, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Parameters. The system displays user-defined Report Set Entry Parameters.
The third section displays tables with information about each Report Set Entry. Report Set Entries are displayed in numerical order.
Report Set Entry Number. For the Report Set Entry identified by its number and title, the report displays the Entry Name, Title, Yes or No settings for Pre Narrative?, Yes or No settings for Post Narrative?, Placeholder, Yes or No settings for Has Children?, and Yes or No settings for Omitted?.
The Pre and Post narratives are also shown with the Report Set Entry's details.
Post-Processing. For Post-processing, the report displays Parameter, Yes or No settings for Default?, Yes or No settings for Value Propagation?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Overlay Templates. For each Overlay Template, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Parameters. The system displays user-defined Report Set Entry Parameters.
Program Instance under Report Set Entry (Full Title). If a Report Set Entry within a Report Set contains a Program instance, then details of the Program definition that this Program instance points to, are displayed.
Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, SAS Name, SAS Library Name, Mapping Status, Mapped to Table Instance, TI (Table Instance) Work Area, TI (Table Instance) Application Area, TI (Table Instance) Domain.
Parameters. For each Program instance Parameter, the report displays the Prompt, Default Value, Yes or No settings for Visible?, and Yes or No settings for Required?.
Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Error if generated?, and Error if not generated?.
Source Code. For each Source Code, the report displays the Name, Description, Yes or No settings for Primary?, Share Type, File Type, Yes or No settings for Sharable?, File Name, Source Code Shared From location and the actual source code.
To generate the Report Set Report, do the following:
Select Reports from the Actions drop-down list in the Report's Properties screen.
Click Go.
Select Definition Report from the list of reports available for Report Sets.
(Optional) Select any of the following optional components to include in the Report Set Definition Report:
Post Processing Parameters
Overlay Templates Parameters
Narratives
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Report Set Instance Report includes all the definitional information that pertains to the instance, including information about the underlying Report Set definition. See "Report Set Report".
This is the same information that is available in the Report Set instance's Properties screen and its subtabs.
The Report Set instance Report has three sections:
Header
Attributes
Child Objects
See "Header Information for Object Instances" for details on the header section.
The second section displays a table with values of the attributes Title, Strict Numbering, and Unique Numbering.
The third section displays tables with information about each of the following Report Set components. The information provided here is the same as that in the Report Set Report. Additionally, you can see mapping information about Table Descriptors.
Planned Output. For each Planned Output, the report displays Name, File Name, Yes or No settings for Primary?, Yes or No settings for Error if generated?, and Error if not generated?.
Post-Processing. For Post-processing, the report displays Parameter, Yes or No settings for Default?, Yes or No settings for Value Propagation?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Overlay Templates. For each Overlay Template, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Parameters. The system displays user-defined Report Set Entry Parameters.
The third section displays tables with information about each Report Set Entry. Report Set Entries are displayed in numerical order.
Report Set Entry Number. For the Report Set Entry identified by its number and title, the report displays the Entry Name, Title, Yes or No settings for Pre Narrative?, Yes or No settings for Post Narrative?, Placeholder, Yes or No settings for Has Children?, and Yes or No settings for Omitted?.
The Pre and Post narratives are also shown with the Report Set Entry's details.
Post-Processing. For Post-processing, the report displays Parameter, Yes or No settings for Default?, Yes or No settings for Value Propagation?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Overlay Templates. For each Overlay Template, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.
Parameters. The system displays user-defined Report Set Entry Parameters.
Program Instance under Report Set Entry (Full Title). If a Report Set Entry within a Report Set contains a Program instance, then details of the Program definition that this Program instance points to, are displayed.
Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, and SAS Name.
Parameters. For each Program instance Parameter, the report displays the Prompt, Default Value, Yes or No settings for Visible?, and Yes or No settings for Required?.
Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Error if generated?, and Error if not generated?.
Source Code. For each Source Code, the report displays the Name, Description, Yes or No settings for Primary?, Share Type, File Type, Yes or No settings for Sharable?, File Name, Source Code Shared From location and the actual source code.
The second subsection displays details about the tables that the Table Descriptors are mapped to. This subsection has two parts, one for the Table Descriptor and the other for the Table instance.
Table Descriptor
Column Name
Data Type
Table Instance
Column Name
Format String
Default Value
Data Type
Mapping Status
To generate the Report Set Instance Report, do the following:
Select Reports from the Actions drop-down list in the Report Set instance's Properties screen.
Click Go.
Select Definition Report from the list of reports available for Report Set instances.
Select all or any of the following optional components to include in the Report Set Instance Report, as required:
Post Processing
Overlay Templates
Narratives
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
A Table Report contains information about the current status of a single Table definition. This is the same information that is available in the Table's Properties screen and its subtabs. For information on a Table's version history, see "Object Version History Report" .
For information on Tables, see Chapter 4, "Defining Tables".
The Table Report has the following three sections:
Header
Attributes
Child Objects
See Header Information for Object Definitions for details on the Header section.
The second section displays the values of the attributes Oracle Name, SAS Name, SAS Label, Process Type, Allow Snapshot?, Blinding Flag, and Blinding Status.
The third section displays tables with information about each of the following Table components:
Note:
These tables display all possible information for each component. Some of the columns may not be applicable to a particular type of Table or to a particular component.Columns. For each Column, the report displays the Name, Position, Oracle Name, SAS Name, SAS Label, Data Type, Length, Precision, SAS Format, Default Value, Mandatory?, and Variable Name.
Constraints. For each Constraint, the report displays the Name, Type, Column Name, Join Table, and Value(s) allowed.
To generate the Table Report:
Select Reports from the Actions drop-down list in the Table's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object definitions.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Table Instance Report includes all the definitional information that pertains to the instance, including information about the underlying Table definition. See "Table Report".
This is the same information that is available in the Table instance's Properties screen and its subtabs.
The Table Instance Report has three sections:
Header
Attributes
Child Objects
See "Header Information for Object Instances" for details on the header section.
The second section displays a table with values of the attributes Oracle Name, SAS Name, SAS Label, Process Type, Allow Snapshot?, Blinding Flag, and Blinding Status.
The third section displays tables with information about each of the following Table components. The information provided here is the same as that in the Table Report. Additionally, you can see mapping information about Table Descriptors.
Table Attributes. The report displays the Table attributes Oracle Name, SAS Name, SAS Label, Process Type, Allow Snapshot?, Blinding Flag, and Blinding Status.
Columns. For each Column, the report displays the Name, Position, Oracle Name, SAS Name, SAS Label, Data Type, Length, Precision, SAS Format, Default Value, Yes or No settings for Mandatory?, and Variable Name.
Constraints. For each Constraint, the report displays the Name, Type, Column Name, Join Table, and Value(s) allowed.
To generate the Table Instance Report:
Select Reports from the Actions drop-down list in the Table instance's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object instances.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Workflow Report contains information about the current status of a single Workflow. This is the same information that is available in the Workflow's Properties screen and its subtabs. For information on a Workflow's version history, see "Object Version History Report".
For more information on Workflows, see Chapter 10, "Defining Workflows".
The Workflow Report has the following two sections:
Header
Child Objects
See Header Information for Object Definitions for details on the Header section.
The third section displays tables with information about each of the following Workflow components:
Note:
These tables display all possible information for each component. Some of the table columns may not be applicable to a particular type of Workflow or to a particular component.Executable Instances and Workflow Structures. For each Executable Instance and Workflow Structure, the report displays the Name, Type, Description, Checked out by, and Status.
Parameters. For each Parameter, the report displays the Prompt, Default Value, Yes or No settings for Visible?, and Yes or No settings for Required?.
Transitions. For each Transition, the report displays From Object Name, From Object Type, Condition, To Object, and To Object Type.
Mapping Details. The report displays information about which executable instances contained in the Workflow are mapped to which Table instances.
The Workflow Report includes information on each executable object instance included in the Workflow. These may include Data Marts, Programs, Load Sets and Report Sets. The information displayed is the same as in the report for each object type. See "Data Mart Report", "Program Report", "Load Set Report", and "Report Set Report".
To generate the Workflow Report:
Select Reports from the Actions drop-down list in the Workflow's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object definitions.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following topics:
The Workflow Instance Report includes all the definitional information that pertains to the instance, including information about the underlying Workflow definition. See "Workflow Report".
This is the same information that is available in the Workflow instance's Properties screen and its subtabs.
The Workflow instance Report has two sections:
Header
Child Objects
See "Header Information for Object Instances" for details on the header section.
The second section displays tables with information about each of the following Workflow components. The information provided here is the same as that in the Workflow Report.
Executable Instances and Workflow Structures. For each Executable Instance and Workflow Structure, the report displays the Name, Type, Description, Checked out by, and Status.
Parameters. For each Parameter, the report displays the Prompt, Default Value, Yes or No settings for Visible?, and Yes or No settings for Required?.
Transitions. For each Transition, the report displays From Object Name, From Object Type, Condition, To Object, and To Object Type.
The Workflow Instance Report contains information on each executable object instance included in the Workflow. The object instances may include Data Marts, Programs, Load Sets and Report Sets. The information displayed is the same as in the report for each object type. See "Data Mart Instance Report", "Program Instance Report", "Load Set Instance Report", and "Report Set Instance Report".
To generate the Workflow Instance Report, do the following:
Select Reports from the Actions drop-down list in the Workflow instance's Properties screen.
Click Go.
Select Definition Report from the list of reports available for object instances.
Click Generate Report. The report opens in Oracle LSH in PDF format.
To open the report in a separate window, click Export and then click Open.
To save the report to your personal computer, do one of the following:
Click Export and then click Save.
Click Save a Copy in the PDF toolbar.
You can print the local copy, if required.
This section contains the following:
Header information for object definitions is divided into two parts:
Domain Name
Application Area Name
Name
Description
Latest Version
Creation Time
Created by
Checked in or out?
Last Modified Time
Last Modified by
Validation Status
Classification
Header information for object instances is divided into three parts as under:
Domain Name
Application Area Name
Work Area Name
Instance Name
Description
Version
Last Modified Time
Last Modified by
Validation Status
Classification
Definition Name
Description
Latest Version
Checked in or out?
Checked out by
Last Modified Time
Last Modified by
Oracle LSH provides the following System Reports. Click a report name to view more information.
All Instances (Work Area) Report; see Work Area - All Instances Report
Cloning Report; see Work Area Cloning Report
Installation History Report; see Work Area Installation History Report
Security Report; see User Group Assignments Report
Version History Report; see Work Area Version History Report