DSV Tables Spec Schema Table
This table describes elements for use in a DSV Tables Extensions spec.
Starting with versions above 2.91 of Blackbaud CRM, the SDK contains XSD (XML Schema Documents that support IntelliSense) and templates for BBDW OLAP extensions specs. These are located in the \Install\SDK\Schemas folder of the installation media. When the SDK is installed, the schema provide IntelliSense when the top level elements for the OLAP extensions specs are used in an XML document.
| DSVDeploymentInfo |
Parent element |
| DSVTableName |
Child of DSVDeploymentInfo. Specifies the name for the new DSV table. |
| DSVSQL |
Child of DSVDeploymentInfo. Contains embedded SQL which selects rows from a BBDW view. |
| DSVTableColumns |
Child of DSVDeploymentInfo. A set of DSVTableColumn. |
| DSVTableColumn |
Child of DSVTableColumns. Using child nodes, specifies column metadata for the new DSV table. |
| ColumnName |
Child of DSVTableColumn. Specifies a column name for a DSV table column. Corresponds to a column in the select list of the embedded SQL contained in DSVSQL. |
| DataType |
Child of DSVTableColumn.Specifies a data type for a DSV table column. |
| DataSize |
Child of DSVTableColumn. Specifies the data size for a DSV table column. |
| Key |
Child of DSVTableColumn. DSV Tables only. Specifies whether a DSV Table column is a key. |
| ColumnAlias |
Child of DSVTableColumn. Fact Extends only. Specifies a column alias for Fact Extensions. |
This table shows the hierarchy for a DSV Tables Extensions spec.
| DSVDeploymentInfo |
|
|
|
| |
DSVTableName |
|
|
| |
DSVSQL |
|
|
| |
DSVTableColumns |
|
|
| |
|
DSVTableColumn |
|
| |
|
|
ColumnName |
| |
|
|
DataType |
| |
|
|
DataSize |
| |
|
|
Key |
| |
|
|
ColumnAlias |