...
| Report Column Name | Description | Source |
|---|---|---|
| Table-View Name | This field displays the name of the Data Warehouse table or view. | MM_TABLE_VIEW.TABLE_NAME |
| Schema | This field displays the schema of the Data Warehouse table or view. | MM_TABLE_VIEW.SCHEMA |
| Type | This field identifies whether the Data Warehouse entity is a table or a view. | MM_ENTITY_TYPE.ENTITY_TYPE_DESC |
| DAL | This field identifies the minimum DAL assigned to the Data Warehouse table or view. | If the value in MM_TABLE_COLUMN_UPDATE.MIN_DAL is null the value is 0, else the value is MM_TABLE_COLUMN_UPDATE.MIN_DAL. |
| Table Comments | This field displays the Data Warehouse table or view comments. | MM_TABLE_VIEW.TABLE_COMMENT |
| Additional Comments | This field displays additional comments about the Data Warehouse table or view. The difference between Table Comments and Additional Comments is the Table Comments were originally derived from the Oracle data dictionary. The Additional Comments were manually added to the MetaMart. | MM_TABLE_VIEW_UPDATE.ADDL_COMMENT |
Columns Page
| Table of Contents | ||
|---|---|---|
|
...
General Filters |
|---|
How to use the General Filters:
- To select a filter value, click on the filter's drop down arrow, then select the value. The values in the report table will update to show the results associated with that value.
- To select multiple values, click on a value, hold down the Ctrl key, and then select the other value(s).
- To remove a filter, either deselect the values in the drop down list.
...
Table/View Count |
|---|
The box displays the count of tables and views that are displayed in the report table. The count adjusts based on filter selections.
...
Column Count |
|---|
The box displays the count of columns in the tables and views that are displayed in the report table. The count adjusts based on filter selections.
...
Report Column Sources |
|---|
The sources used to population the fields in the report are derived from the MetaMart tables (Database: REPO, Schema: META).
| Report Column Name | Description | Source |
|---|---|---|
| Table-View Name | This field displays the name of the Data Warehouse table or view. | MM_TABLE_VIEW.TABLE_NAME |
| Column Name | ||
| Col DAL | ||
| Datatype | ||
| Nullable | ||
| Data Source | ||
| Column Comments | ||
| Additional Comments |