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 | ||
| Type | ||
| DAL | ||
| Table Comments | ||
| Additional Comments |
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 | ||
| Col DAL | ||
| Datatype | ||
| Nullable | ||
| Data Source | ||
| Column Comments | ||
| Additional Comments |