Web Intelligence Dataproviders (BI4).
Column Name |
Data Type |
Description |
|---|---|---|
DATAPROVIDERID |
varchar |
Unique dataprovider ID |
DATAPROVIDERTYPE |
varchar |
Dataprovider type |
DATASOURCENAME |
nvarchar |
Datasource name of dataprovider (typically universe name) |
DATASOURCETYPE |
varchar |
Datasouce type of dataprovider |
DURATION |
int |
Duration of dataprovider refresh |
ID |
int |
Primary key |
ISSAMPLED |
bit |
Is dataprovider sampled data only? |
ISSAP |
bit |
Is dataprovider SAP based? |
NAME |
nvarchar |
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.) |
REFRESHDATE |
datetime |
Date of last saved refresh of dataprovider |
ROWCOUNT |
int |
Rowcount of data rows stored in the dataprovider |
UNIVERSECUID |
varchar |
Universe CUID used by the dataprovider |
UNIVERSENAME |
nvarchar |
Universe Name used by the dataprovider |
WEBI1400DOCUMENT_ID |
int |
Foreign key to WEBI1400_DOCUMENTS.ID |
See also