Web Intelligence Document Objects (XI3).
Column Name |
Data Type |
Description |
---|---|---|
ASSOCIATEDDIMENSION |
varchar |
Associated dimension object if the object is a detail |
CLASSLINEAGE |
nvarchar |
Class lineage of the object (to the root of the universe) |
CLASSNAME |
nvarchar |
Class name to which the object belonds |
CONDITIONCATEGORY |
int |
Condtion category |
DATAPROVIDERID |
varchar |
ID of the dataprovider to which the object belonds |
DEFAULTVALUES |
varchar |
Default values of the object if it’s a condition object |
DSOBJID |
varchar |
Datasource Object ID or unique identified of the object |
FORMULA |
nvarchar |
Formula, if the object is a report-level variable |
FORMULALANGUAGEID |
varchar |
Formula ID if the object is a report-level variable |
ID |
int |
Primary key |
ISCONDITION |
bit |
If the object is a condition object, =1, else = 0 |
ISVALID |
bit |
If the object is valid , =1 else, =0 |
LASTUSEDVALUES |
varchar |
If the object is a prompt, this displays the last used values |
OBJECTDESCRIPTION |
varchar |
Description of the object |
OBJECTNAME |
nvarchar |
Name of the object |
OBJECTTYPE |
varchar |
Type of object |
OPERATOR |
varchar |
Operator used on the result object |
PROMPTNAME |
varchar |
Prompt name |
QUALIFICATION |
varchar |
Qualification |
QUERYID |
varchar |
Query ID from which the object originates |
UNIVERSECUID |
varchar |
Universe CUID associated with the object |
UUOBJID |
varchar |
Universally unique object ID of the Webi result, condition or variable object |
WEBI_DATAPROVIDERQUERIES_ID |
int |
Foreign key to WEBI1200_DATAPROVIDERQUERIES.ID |
WEBI1200_DATAPROVIDER_ID |
int |
Foreign key to WEBI1200_DATAPROVIDERS.ID |
WEBI1200_DOCUMENT_ID |
int |
Foreign key to WEBI1200_DOCUMENTS.ID |
See also