When restrictions are placed on actual table/columns of a database table, MetaMiner scans this metadata and stores them in the MMDB. They are reportable by using the universe objects below. The image beneath illustrates how these restrictions are configured in Universe Designer.
Universe Class |
Object Name |
Description / Purpose |
---|---|---|
Table Name |
The tablename where the restriction has been added |
|
Where Clause |
The where clause that specifies the SQL behaviour of the restriction, e.g. SALES_METRICS.REGION = 'West' |
See also