Dimensional Usage Spec Exercise Steps

  1. From an editor such as Notepad, Notepad++, or Visual Studio's XML editor, create a new XML document called Exercise_Ext.DimensionalUsage.
  2. Paste the following skeletal markup into your document:

    <DimensionalUsageDeploymentInfo>
      <Cube>BBDW</Cube>
      <DimensionID></DimensionID>
      <DimensionName></DimensionName>
      <MeasureGroupRelationships>
        <MeasureGroupRelationship>
          <RelationshipType></RelationshipType>
          <MeasureGroup></MeasureGroup>
          <MeasureGroupRelatedColumn></MeasureGroupRelatedColumn>
          <DimensionKeyAttributeID></DimensionKeyAttributeID>
        </MeasureGroupRelationship>
      </MeasureGroupRelationships>
    </DimensionalUsageDeploymentInfo>
  3. Adjust the markup for a new dimensional usage. For this exercise, establish a regular relationship between a dimension and a measure group.
  4. Save the file.