OLAPDATASOURCE
Contains one row for each Analysis Services OLAP/UDM data source that has been configured for they system.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| SOURCENAME |
nvarchar(255) |
|
Default = '' |
A friendly name to present to the end user when choosing a datasource |
| SOURCEDESCRIPTION |
nvarchar(2048) |
|
Default = '' |
A description of this data source |
| MARTKEY |
nvarchar(255) |
|
Default = '' |
The Mart key from the Mart Manifest file that generated this row |
| CONNECTIONSTRING |
nvarchar(2048) |
|
Default = '' |
|
| IMPERSONATE |
bit |
|
Default = 0 |
1 if a user should be impersonated when connecting to this datasource |
| IMPERSONATEUSERACCOUNTSID |
varbinary |
yes |
|
|
| IMPERSONATEUSERNAME |
nvarchar(128) (Computed) |
yes |
SUSER_SNAME(IMPERSONATEUSERACCOUNTSID) |
Computed name of the IMPERSONATEUSERACCOUNTSID column value |
| IMPERSONATEUSERPWD |
nvarchar(4000) |
|
Default = '' |
|
| IMPERSONATELOCALUSERNAME |
nvarchar(255) |
|
Default = '' |
The name of a local user to impersonate for the connection. |
| UDMDEPLOYMENTMANIFEST |
xml |
yes |
|
The contents of the udm deployment manifest that created this datasource. |
| ETLSERVERNAME |
nvarchar(128) |
|
Default = '' |
Name of SQL Server where the ETL SQL Agent job is configured. |
| ETLJOBNAME |
nvarchar(255) |
|
Default = '' |
Name of SQL Server SQL Agent job that invokes the data mart refresh. |
| ETLJOBSTEPNAME |
nvarchar(255) |
|
Default = '' |
Name of SQL Server SQL Agent job step that invokes the data mart refresh. |
| MARTMANIFEST |
xml |
|
|
The contents of the data mart deployment manifest that created this datasource. |
| ETLDATABASENAME |
nvarchar(128) |
|
Default = '' |
Name of SQL Server database where the ETL control table and ETL reset procedure are located. |
| ISOLAP |
bit |
|
Default = 0 |
True if this data source has an OLAP cube. If false then the data source if just used for relational data. |
| OLAPCLIENT_HTTP_DATASOURCE_URL |
UDT_WEBADDRESS |
|
Default = '' |
The url to use for OLAP clients (such as Excel) for access to the Analysis Services server via HTTP. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| INCLUDESELECTIONS |
bit |
|
Default = 0 |
|
| VALIDATIONPROCESSID |
uniqueidentifier |
yes |
|
|
| ETLMAXPARALLELISM |
int |
|
Default = 1 |
|
| DATEQUERYNAME |
nvarchar(128) |
|
Default = '' |
|
| DATEQUERYKEYCOLUMN |
nvarchar(128) |
|
Default = '' |
|
| SUPPORTSROLLINGDATES |
bit |
|
Default = 0 |
|
| DATAWINDOWREFERENCE |
datetime |
yes |
|
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| OLAPDATASOURCECATEGORYCODEID |
uniqueidentifier |
yes |
OLAPDATASOURCECATEGORYCODE.ID
|
FK to Olap Data Source Category Code table. |
| BEFORE_ETL_QUEUEPROCESSID |
uniqueidentifier |
yes |
QUEUEPROCESS.ID
|
The ID of a Queue business process to run before the Etl starts. |
| AFTER_ETL_QUEUEPROCESSID |
uniqueidentifier |
yes |
QUEUEPROCESS.ID
|
The ID of a Queue business process to run after the Etl ends. |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_OLAPDATASOURCE_DATEADDED |
DATEADDED |
|
|
yes |
| IX_OLAPDATASOURCE_DATECHANGED |
DATECHANGED |
|
|
|
| PK_OLAPDATASOURCE |
ID |
yes |
yes |
|
| UC_OLAPDATASOURCE_SOURCENAME |
SOURCENAME |
yes |
|
|
Triggers
Referenced by