DSV Spec Exercise Steps (Wizard Version)

This is applicable to the SDK for Blackbaud CRM versions 2.93 and higher.

1. Ensure you have added a database revision to the Blackbaud Data Warehouse database for DIM_EVENT_EXT. For more information, see Revisions Extensions Exercises.

2. Run the DSV Table Wizard. For step-by-step guidance, see Run the DSV Table Wizard.

3. In Name, enter DSVTable.Event_Ext.xml.

   

4. Click Add. The wizard appears.

5. Click the binoculars. The Select a table screen appears.

6. If necessary, connect to the server and the database. Then, from Table, select DIM_EVENT_EXT.

   

7. Click OK.

8. In DSV Table Name, enter DIM_EVENT_EXT.

9. Select the following columns:

   • EVENTDIMID

   • EVENTSYSTEMID

   • PARENTEVENTDIMID

   • EVENTLOOKUPID

   • EVENTNAME

   • EVENTDESCRIPTION

   • EVENTCAPACITY

   • EVENTCATEGORY

   • EVENTSTARTDATE

   • EVENTENDDATE

   • EVENTISACTIVE

10. From Key, select EVENTDIMID.

    

11. Click OK. The wizard should create a spec like this:

    <DSVDeploymentInfo xmlns="bb_olap_dsv">
      <DSVTableName>DIM_EVENT_EXT</DSVTableName>
      <DSVSQL>
        select
          [EVENTCAPACITY]
          [EVENTCATEGORY]
          [EVENTDESCRIPTION]
          [EVENTDIMID]
          [EVENTENDDATE]
          [EVENTISACTIVE]
          [EVENTLOOKUPID]
          [EVENTNAME]
          [EVENTSTARTDATE]
          [EVENTSYSTEMID]
          [PARENTEVENTDIMID]
        from BBDW.[DIM_EVENT_EXT]
      </DSVSQL>
      <DSVTableColumns>
        <DSVTableColumn>
          <ColumnName>EVENTCAPACITY</ColumnName>
          <DataType>Int32</DataType>
          <DataSize>0</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTCATEGORY</ColumnName>
          <DataType>String</DataType>
          <DataSize>255</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTDESCRIPTION</ColumnName>
          <DataType>String</DataType>
          <DataSize>255</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTDIMID</ColumnName>
          <DataType>Int32</DataType>
          <DataSize>0</DataSize>
          <Key>true</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTENDDATE</ColumnName>
          <DataType>DateTime</DataType>
          <DataSize>0</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTISACTIVE</ColumnName>
          <DataType>Boolean</DataType>
          <DataSize>0</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTLOOKUPID</ColumnName>
          <DataType>String</DataType>
          <DataSize>100</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTNAME</ColumnName>
          <DataType>String</DataType>
          <DataSize>255</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTSTARTDATE</ColumnName>
          <DataType>DateTime</DataType>
          <DataSize>0</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>EVENTSYSTEMID</ColumnName>
          <DataType>Guid</DataType>
          <DataSize>0</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
        <DSVTableColumn>
          <ColumnName>PARENTEVENTDIMID</ColumnName>
          <DataType>Int32</DataType>
          <DataSize>0</DataSize>
          <Key>false</Key>
        </DSVTableColumn>
      </DSVTableColumns>
    </DSVDeploymentInfo>