User Defined Attribute Administration View: Real UDAs without Dimension

The following view contains a list of User Defined Attributes (UDAs) that have UDA Type (UTYPE) set to REAL but have no dimension assigned for unit of measure qualification.

Example

NEW DBVW

UDNA 'UDAs : Reals without Dimension'

ELEL ADD UDA

NEW ATTFILTER

DBATTRIBUTE UTYP

FILTOPERATOR 'Equals'

FILTVALUE 'REAL'

END

NEW ATTFILTER

DBATTRIBUTE UUNI

FILTOPERATOR 'Equals'

FILTVALUE 'NONE'

END

NEW ATTCOLUMN

DBATTRIBUTE UDNA

END

NEW ATTCOLUMN

DBATTRIBUTE NAME

END

NEW ATTCOLUMN

DBATTRIBUTE OWNER

UDNA 'UGROUP'

READONLY true

END

NEW ATTCOLUMN

DBATTRIBUTE UDNA

END

NEW ATTCOLUMN

DBATTRIBUTE NAME

END

NEW ATTCOLUMN

DBATTRIBUTE OWNER

UDNA 'UGROUP'

READONLY true

END

END

Since the Data content of this example is available from within Lexicon the results can be seen immediately using the Database Views Editor.