Data Warehouse Tables/Views Documentation Report
- Revati Vogeti
- Julie Schneider
This report displays Data Warehouse (DWHOUSE) tables and views available through Data Access Level (DAL) security.
Tables-Views Page
This page displays the Data Warehouse tables and views with a DAL assignment.
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
This page displays the columns in the Data Warehouse Tables and Views that have a DAL assignment.
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. | MM_TABLE_COLUMN.COLUMN_NAME |
| Col DAL | This field identifies the minimum DAL assigned to the column. | If the value in MM_TABLE_COLUMN_UPDATE.MIN_DAL is null then the value in MM_TABLE_VIEW_UPDATE.MIN_DAL is used, else the value in MM_TABLE_COLUMN_UPDATE.MIN_DAL is used. |
| Datatype | This field identifies the column datatype. | MM_TABLE_COLUMN.COLUMN_DATATYPE |
| Nullable | This field identifies whether or not the column value can be null. | MM_TABLE_COLUMN.NULLABLE |
| Data Source | This field displays the source of the data in the column. | MM_TABLE_COLUMN_UPDATE.SOURCE |
| Column Comments | This field displays the column comments. | MM_TABLE_COLUMN.COLUMN_COMMENT |
| 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. | MM_TABLE_COLUMN_UPDATE.ADDL_COMMENT |
IT Analytics, SVC4010, Contact Us