This report displays Data Warehouse (DWHOUSE) tables and views available through Data Access Level (DAL) security.
Tables-Views Page
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.
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 |
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
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 | This field displays the name of the column in the Data Warehouse table or view. | |
Col DAL | This field identifies the minimum DAL assigned to the column. | |
Datatype | This field identifies the column datatype. | |
Nullable | This field identifies whether or not the column value can be null. | |
Data Source | This field displays the source of the data in the column. | |
Column Comments | This field displays the column comments. | |
Additional Comments | This field displays the additional column comments. The difference between Column Comments and Additional Comments is the Column Comments were originally derived from the Oracle data dictionary. The Additional Comments were manually added to the MetaMart. |