Dimensions Extensions Specs

Reference tables for this spec are located at Dimensions Spec Schema Table

With Dimensions Extensions specs, you can specify to create dimensions to use within the cube. The spec defines the dimension name and ID along with the dimension's attributes information and the attribute keys. Once processed, a dimension table based on the spec is added to the cube.

Dimensions Extensions specs do not establish a relationship between the dimension and any measure groups. To establish usage of a dimension by a measure group, use the Dimensional Usage Extensions spec. For more information, see Dimensional Usage Extensions Specs.

A Dimensions Extensions spec looks like this:

<DimensionDeploymentInfo>
  <DimensionID>Installment</DimensionID>
  <DimensionName>Installment</DimensionName>
  <DimensionAttributes>
    <DimensionAttribute>
      <AttributeID>INSTALLMENTFACTID</AttributeID>
      <AttributeName>Installment Fact ID</AttributeName>
      <AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
      <AttributeHierarchyVisible>false</AttributeHierarchyVisible>
      <Usage>Key</Usage>
      <KeyColumns>
        <AttributeKeyColumn>
          <DataType>Integer</DataType>
          <TableID>FACT_INSTALLMENT</TableID>
          <ColumnID>INSTALLMENTFACTID</ColumnID>
        </AttributeKeyColumn>
      </KeyColumns>
    </DimensionAttribute>
  </DimensionAttributes>
</DimensionDeploymentInfo>