Report level varibles found in Webi BI4 reports.
Column Name |
Data Type |
Description |
|---|---|---|
ASSOCIATEDDIMENSIONID |
varchar |
If the variable is a detail, this provides info around the associated dimension |
DATASOURCEOBJECTID |
varchar |
Base object of the variable |
DEFINITION |
nvarchar |
Definition of the formula/variable as it was created in Webi |
DESCRIPTION |
nvarchar |
Description of the variable |
FORMULALANGUAGEID |
nvarchar |
Formula of the ??????????????????????????? |
ISMERGEDDIMENSION |
bit |
Is the object a merged dimension? |
ISREPORTUSABLEOBJECT |
bit |
Is the object usable? |
NAME |
varchar |
The name of the object, in many cases the equivalent of SI_ID in the CMS/Query Builder when referring to a base CMS object type (USERS, SEMANTICLAYER etc.) |
QUALIFICATIONNAME |
varchar |
Detects whether the object is a dimension, measure or detail |
VARIABLEID |
varchar |
Internal BI4 / Webi if of the variable, usually starts with "L" |
WEBI1400DOCUMENT_ID |
int |
Foreign key to WEBI1400_DOCUMENTS.ID |
See also