Table UNV_OBJECTS

Universe Object Metadata Properties.

Column Name	Data Type	Description
AGGREGATEFUNCTION	nvarchar	Is the object an aggregate function?
ASSOCIATEDDIMENSION	nvarchar	If itвЂ™s a detai what's the associated dimension's object name?
ASSOCIATEDDIMENSIONID	int	If itвЂ™s a detail, what's the associated dimension's object ID?
CLASSID	int	Class ID of the object
CLASSNAME	nvarchar	Class name of the object
CMSID	varchar	The actualy name of the CMS host machine without the port number, if used. В This is used in conjunction with OBJECTID or CUID to uniquely identify an object across environments
CONDITIONTYPE	nvarchar	Condition type
CREATED	datetime	The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME
CUSTOMLOVSQL	nvarchar	Custom LOV SQL (NOT USED)
DBFORMAT	nvarchar	Database format of the object
HASLOV	bit	has LOV associated with it?
ID	int	Primary key
ISALLOWEDEDITLOV	bit	Can users edit the LOV?
ISALLOWEDINCONDITION	bit	Is it allowed in a condition?
ISALLOWEDINRESULT	bit	Is it allowed in a result?
ISALLOWEDSORTING	bit	Is sorting allowed on it?
ISAUTOREFRESHLOV	bit	Is the LOV automatically refreshed with each use?
ISCONDITION	bit	Is the object a condition?
ISCUSTOMLOV	bit	Is a custom LOV associated with the object?
ISEXPORTLOV	bit	Can the LOV be exported with the Universe?
ISHIDDEN	bit	Is the object hidden?
LINEAGE	nvarchar	Lineage (Class parent paths)
OBJECTDESCRIPTION	nvarchar	Description of the object
OBJECTID	int	Unique OBJECTID of the Universe dimension/measure/detail/condition object
OBJECTNAME	nvarchar	Object name
ORDINAL	int	Order in which the object appears in the Universe tree
QUALIFICATION	nvarchar	Type of object (measure, dimension, detail, condition)
REALSELECTEXPRESSION	nvarchar	Select SQL with references and @ functions resolved
REALWHEREEXPRESSION	nvarchar	Where SQL
SECURITYLEVEL	nvarchar	Security level
SELECTEXPRESSION	nvarchar	Select SQL including references and @ functions
TABLES	nvarchar	Tables associated with the object
UNIVERSECUID	varchar	Universe CUID
UNIVERSEMUID	varchar	Universe CUID + CMS Server
UNV_CLASSES_ID	int	Foreign key to UNV_CLASSES.ID
UNV_UNIVERSES_ID	int	Foreigh key to UNV_UNIVERSES.ID
UPDATED	datetime	Datetime that this object was updated in the BusinessObjects CMS
UPDATED_CMS	datetime	Last time object was updated in the CMS
WHEREEXPRESSION	nvarchar	Where SQL