Dimension GetAttributeColumns

Gets the attribute value and element ID of each dimension element for the specified attribute field in the specified attribute table of the specified dimension.

Request

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="129" Class="Dimension" Method="GetAttributeColumns">
    <Alea:Attributes Dimension="CURR">
      <Alea:Column Caption="true" />
      <Alea:Column AttribTableID="1" FieldName="OrderPos" />
      <Alea:Column AttribTableID="2" FieldName="French" />
    </Alea:Attributes>
  </Alea:Request>
</Alea:Document>

Answer

<Alea:Document>
  <Alea:Request RequestID="129">
    <Alea:Return>
      <Alea:Attributes Dimension="CURR">
        <Alea:Column Caption="true">
          <Alea:Attribute AttribValue="CHF" ElemId="1" />
          <Alea:Attribute AttribValue="EUR" ElemId="3" />
          <Alea:Attribute AttribValue="GBP" ElemId="4" />
          <Alea:Attribute AttribValue="HKD" ElemId="5" />
          [...]
        </Alea:Column>
        <Alea:Column AttribTableID="1" FieldName="OrderPos">
          <Alea:Attribute AttribValue="0" ElemId="1" />
          <Alea:Attribute AttribValue="0" ElemId="2" />
          <Alea:Attribute AttribValue="0" ElemId="3" />
          <Alea:Attribute AttribValue="0" ElemId="4" />
          <Alea:Attribute AttribValue="0" ElemId="5" />
          [...]
        </Alea:Column>
        <Alea:Column AttribTableID="2" FieldName="French">
          <Alea:Attribute AttribValue="CHF" ElemId="1" />
          <Alea:Attribute AttribValue="EUR" ElemId="3" />
          <Alea:Attribute AttribValue="GBP" ElemId="4" />
          <Alea:Attribute AttribValue="HKD" ElemId="5" />
          [...]
        </Alea:Column>
      </Alea:Attributes>
    </Alea:Return>
  </Alea:Request>
</Alea:Document>

If AttribTableID or FieldName in <Alea:Column> are missing in the request or the corresponding field does not exist, and Caption is set to true, the value of the Caption attribute field of attribute table 1 is returned. If this field does not exist, then an error is returned.

If AttribTableID and FieldName in <Alea:Column> are specified and the corresponding field exists, then Caption is not relevant.

If the attribute value is empty, then <Alea:Attribute> is not returned for this dimension element.

Attribute values are returned without escaping, unlike Dimension Read.

Answer

<Alea:Document>
  <Alea:Request RequestID="129">
    <Alea:Return>
      <Alea:Attributes Dimension="CURR">
        <Alea:Column Caption="true">
          <Alea:Attribute AttribValue="CHF" ElemId="1" />
          <Alea:Attribute AttribValue="EUR" ElemId="3" />
          <Alea:Attribute AttribValue="GBP" ElemId="4" />
          <Alea:Attribute AttribValue="HKD" ElemId="5" />
          [...]
        </Alea:Column>
        <Alea:Column AttribTableID="1" FieldName="OrderPos">
          <Alea:Attribute AttribValue="0" ElemId="1" />
          <Alea:Attribute AttribValue="0" ElemId="2" />
          <Alea:Attribute AttribValue="0" ElemId="3" />
          <Alea:Attribute AttribValue="0" ElemId="4" />
          <Alea:Attribute AttribValue="0" ElemId="5" />
          [...]
        </Alea:Column>
        <Alea:Column AttribTableID="2" FieldName="French">
          <Alea:Attribute AttribValue="CHF" ElemId="1" />
          <Alea:Attribute AttribValue="EUR" ElemId="3" />
          <Alea:Attribute AttribValue="GBP" ElemId="4" />
          <Alea:Attribute AttribValue="HKD" ElemId="5" />
          [...]
        </Alea:Column>
      </Alea:Attributes>
    </Alea:Return>
  </Alea:Request>
</Alea:Document>

Related topics