This This report displays Data Warehouse (DWHOUSE) tables and views available through Data Access Level (DAL) security.
Table of Contents | ||
---|---|---|
|
Tables-Views Page
Table of Contents | ||
---|---|---|
|
This page displays the Data Warehouse tables and views with a DAL assignment.
...
General Filters |
---|
How to use the General Filters:
...
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 | ||
---|---|---|
|
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:
...
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