Dimensions Spec Exercise Steps (Wizard Version)

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

  1. Run the Dimension Wizard. For step-by-step guidance, see Run the Dimension Wizard.

  2. In Name, enter Dimension.Event_Ext.xml.

  3. Click Add. The wizard appears.

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

  5. If necessary, connect to the server and the database. Then, from DSV Table, select DIM_EVENT_EXT, the DSV table you created in DSV Spec Exercise Steps (Wizard Version).

  6. Click OK.

  7. Ensure that EVENTDIMID is the selected Key Attribute.

  8. Click >>.

  9. From the Attributes screen of the wizard, select attributes and adjust the properties of each attribute to match the following.

    You can edit properties directly from the properties grid that displays for the selected attribute. You can also click the edit (pencil) button to edit an attribute's properties.

    AttributeID: EVENTDIMID

    • AttributeName: Event
    • AttributeHierarchyVisible: false
    • Usage: Key
    • OrderBy: Name

    AttributeID: EVENTNAME

    Re

    AttributeID: EVENTSYSTEMID

    • AttributeName: Event System ID
    • AttributeHierarchyEnabled: false
    • AttributeHierarchyVisible: false

    AttributeID: PARENTEVENTDIMID

    • AttributeName: Event Hierarchy
    • Usage: Parent
    • NamingTemplate: Event Level *;
    • RootMemberIf: ParentIsBlankSelfOrMissing

    AttributeID: EVENTLOOKUPID

    • AttributeName: Event Lookup ID
    • AttributeHierarchyEnabled: false

    AttributeID: EVENTDESCRIPTION

    • AttributeName: Event Description
    • AttributeHierarchyEnabled: false

    AttributeID: EVENTCAPACITY

    • AttributeName: Event Capacity
    • AttributeHierarchyEnabled: false

    AttributeID: EVENTCATEGORY; AttributeName: Event Category

    AttributeID: EVENTSTARTDATE;

    • AttributeName: Event Start Date
    • AttributeHierarchyEnabled: false

    AttributeID: EVENTENDDATE

    • AttributeName: Event End Date
    • AttributeHierarchyEnabled: false

    AttributeID: EVENTISACTIVE; AttributeName: Event Is Active

  10. Click >>. Click >> again.

  11. From the Hierarchies screen of the wizard, click the green + button.

  12. In Hierarchy Name, enter Event Category - Event.

  13. Click the green + button to add a hierarchy level and select Event Category under Source Attribute in the row that appears.

  14. Add another level for Event.

  15. Click OK.

  16. Click OK.

  17. Complete the wizard to create a dimension for Dimension.Installment_Ext.xml.

  18. The completed spec for the Event Extend dimension should look like this:

    <DimensionDeploymentInfo xmlns="bb_olap_dimension">
  <DimensionID>DIM_EVENT_EXT</DimensionID>
  <DimensionName>DIM_EVENT_EXT</DimensionName>
  <DimensionAttributes>
    <DimensionAttribute>
      <AttributeID>EVENTCAPACITY</AttributeID>
      <AttributeName>Event Capacity</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>false</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTCAPACITY</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTCAPACITY</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTCATEGORY</AttributeID>
      <AttributeName>Event Category</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTCATEGORY</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTCATEGORY</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTDESCRIPTION</AttributeID>
      <AttributeName>Event Description</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTDESCRIPTION</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTDESCRIPTION</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTDIMID</AttributeID>
      <AttributeName>Event</AttributeName>
      <Usage>Key</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>false</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTDIMID</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTDIMID</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTENDDATE</AttributeID>
      <AttributeName>Event End Date</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>false</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTENDDATE</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTENDDATE</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTISACTIVE</AttributeID>
      <AttributeName>Event Is Active</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTISACTIVE</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTISACTIVE</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTLOOKUPID</AttributeID>
      <AttributeName>Event Lookup ID</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTLOOKUPID</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTLOOKUPID</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTNAME</AttributeID>
      <AttributeName>EVENTNAME</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTNAME</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTNAME</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTSTARTDATE</AttributeID>
      <AttributeName>Event Start Date</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>false</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTSTARTDATE</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTSTARTDATE</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>EVENTSYSTEMID</AttributeID>
      <AttributeName>Event System ID</AttributeName>
      <Usage>Regular</Usage>
      <OrderBy>Name</OrderBy>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>false</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>false</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>EVENTSYSTEMID</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>EVENTSYSTEMID</ColumnID>
      </NameColumn>
    </DimensionAttribute>
    <DimensionAttribute>
      <AttributeID>PARENTEVENTDIMID</AttributeID>
      <AttributeName>Event Hierarchy</AttributeName>
      <Usage>Parent</Usage>
      <OrderBy>Name</OrderBy>
      <NamingTemplate>Event Level *;</NamingTemplate>
      <RootMemberIf>ParentIsBlankSelfOrMissing</RootMemberIf>
      <InstanceSelection>None</InstanceSelection>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>true</AttributeHierarchyVisible>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataSize>0</DataSize>
          <TableID>DIM_EVENT_EXT</TableID>
          <ColumnID>PARENTEVENTDIMID</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
      <NameColumn>
        <DataSize>0</DataSize>
        <TableID>DIM_EVENT_EXT</TableID>
        <ColumnID>PARENTEVENTDIMID</ColumnID>
      </NameColumn>
    </DimensionAttribute>
  </DimensionAttributes>
  <Hierarchies>
    <Hierarchy>
      <HierarchyName>Event Category - Event</HierarchyName>
      <HierarchyLevels>
        <HierarchyLevel>
          <HierarchyLevelName>Event Category</HierarchyLevelName>
          <SourceAttribute>Event Category</SourceAttribute>
        </HierarchyLevel>
        <HierarchyLevel>
          <HierarchyLevelName>Event</HierarchyLevelName>
          <SourceAttribute>Event</SourceAttribute>
        </HierarchyLevel>
      </HierarchyLevels>
    </Hierarchy>
  </Hierarchies>
</DimensionDeploymentInfo>