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-unv-table-row-restrictions

 

Universe Class

Object Name

Description / Purpose

universe-restricted-rows

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

MetaMiner Database Fields

 

© 2013-2015 by Infolytik