Skip Headers

Oracle® Argus Analytics User's Guide Release 1.1 E29106-01 |
| Contents | Index

Previous | Next |

# B Oracle Argus Analytics Presentation Catalog

The Oracle Argus Analytics Presentation Catalog displays columns that you can use to create requests.

This appendix contains the following topics:

- Dimensions in Oracle Argus Analytics Presentation Catalog

- Facts and Sources in Oracle Argus Analytics Presentation Catalog

See Also:

Chapter 3, "Working with Reports"

## Dimensions in Oracle Argus Analytics Presentation Catalog

Table B-1 describes the Dimensions displayed in the Oracle Argus Analytics Presentation Catalog. For each column, it shows the name of the Column, its description, and the Dimension containing the column. The table is sorted by Dimension, and by Column within Dimension. This corresponds to how the Dimension columns are organized in the Presentation Catalog.

Please note that some columns have been de-normalized, so that they appear in more than one Dimension. This de-normalization speeds query execution by eliminating the need for a join to that column in another Dimension. It also supports the ability to constrain columns in a Prompt, so that when you select a value in one column, the other columns are constrained to those related to your selection. When you select a de-normalized column from a Dimension, your results will be limited to the grain of the Dimension.

Table B-1 Presentation Catalog - Dimensions

Dimension | Column | Description
--- | --- | ---
Case Processing Site | Case Processing Site | Case Processing Site that the user belongs to.
Enterprise | Enterprise ID | CRO Enterprise (Client) Short Name
Enterprise | Enterprise Name | Enterprise Name
Period | Year | Per_name_year From W_day_d Table
Period | Quarter | Per_name_qtr From W_day_d Table
Period | Month | Per_name_month From W_day_d Table
Period | Week | Per_name_week From W_day_d Table
Period | Day | Calendar_date From W_day_d Table
Product | Product Group | Therapeutic Alignment Of User Groups By Product Indication (For Example, Oncology Group, Gynecology Group Etc)
Product | Product Family | Product Family - It is used to group Like products that share Datasheets and Primary Ingredients.
Product | PSUR Group | PSUR Group Name
Product | Product Name | Product Name
Product | Product Formulation | Formulation of the Product
Product | Product Concentration | Concentration/Strength of the Product
Study | Study ID | Study ID
Study | Project ID | Project ID for Study
Product | Generic Name | Generic Name of the Product
License | Product Name | Product Name
License | Product Formulation | Formulation of the Product
License | Product Concentration | Concentration/Strength of the Product
License | License ID | Product License Number
License | License Type | Product License Type (like Marketed Drug, Investigational Vaccine etc.)
License | License Name | Concatenated value of license trade name, license authorization country and license number displayed as - trade name || ' (' || country|| ') ' || license number
License | License MAH | Manufacturer of the licensed product
License | License Country | Country of license award
License | CTPR Group | CTPR Group Name
License | Trade Name | Trade Name
Report Destination | Report Destination Country | Country of destination to which the report is submitted
Report Destination | Report Destination | Destination to which the report is submitted

## Facts and Sources in Oracle Argus Analytics Presentation Catalog

This section contains an embedded Excel sheet that lists the Facts and Sources displayed in the Oracle Argus Analytics Presentation Catalog.

For each Column, it shows the name of the Column, its description, and the Fact and Group within the Fact that contain the Column. The sheet is sorted by Group and Column, within Fact.

This corresponds to how the Fact columns are organized in the Presentation Catalog, within the Fact folder. The embedded Excel sheet also describes how Oracle Argus Analytics populates each column from an Oracle Argus Safety database.

To view the table in the embedded Excel sheet, double-click this paperclip icon. Alternately, you can also right-click the icon and click Open File.

To save the Excel sheet to your local machine, right-click the icon and click the Save Embedded File to Disk... option.