Dimensions 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.Dimension.xml.
  2. Paste the following skeletal markup into your document:

    <DimensionDeploymentInfo>  
      <DimensionName></DimensionName>
      <DimensionAttributes>
        <DimensionAttribute>
          <AttributeID></AttributeID>
          <AttributeName></AttributeName>
          <AttributeHierarchyVisible></AttributeHierarchyVisible>
          <Usage></Usage>
          <OrderBy></OrderBy>
          <KeyColumns>
            <AttributeKeyColumn>
              <TableID></TableID>
              <ColumnID></ColumnID>
            </AttributeKeyColumn>
          </KeyColumns>
          <NameColumn>
            <DataType></DataType>
            <TableID></TableID>
            <ColumnID></ColumnID>
          </NameColumn>
        </DimensionAttribute>
      </DimensionAttributes>
      <Hierarchies>
        <Hierarchy>
          <HierarchyName></HierarchyName>
          <HierarchyLevels>
            <HierarchyLevel>
              <SourceAttribute></SourceAttribute>
            </HierarchyLevel>
            <HierarchyLevel>
              <SourceAttribute></SourceAttribute>
            </HierarchyLevel>
          </HierarchyLevels>
        </Hierarchy>
      </Hierarchies>
    </DimensionDeploymentInfo>
  3. Adjust the markup for a new dimension.
  4. Save the file.