Excel Client:ElemAttributDimElement: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
|||
| Line 1: | Line 1: | ||
==[[Excel_Client:Functions_(Formulas)|Function]]== | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>ElemAttributeDimElement(DimensionName, ElementName, | <span {{CoPFormel}}>ElemAttributeDimElement(DimensionName, ElementName, Attribut)</span> | ||
Through this [[Excel_Client:Functions_(Formulas)|Function]] an attribute of a dimension member or lookups can be read (Dimension Manager Windows client). The function is volatile (runs every computation of the worksheet). The name of the attribute will be returned. | Through this [[Excel_Client:Functions_(Formulas)|Function]] an attribute of a dimension member or lookups can be read (Dimension Manager Windows client). The function is volatile (runs every computation of the worksheet). The name of the attribute will be returned. | ||
| Line 17: | Line 17: | ||
|Name of the element whose attribute is to be read | |Name of the element whose attribute is to be read | ||
|- | |- | ||
| | |Attribut | ||
|Name of the attribut (Column name) | |Name of the attribut (Column name) | ||
|} | |} | ||
Latest revision as of 10:13, 21 May 2015
Function
ElemAttributeDimElement(DimensionName, ElementName, Attribut)
Through this Function an attribute of a dimension member or lookups can be read (Dimension Manager Windows client). The function is volatile (runs every computation of the worksheet). The name of the attribute will be returned.
| Parameter | Description |
| DimensionName | Name of the dimension, which contains the element |
| ElementName | Name of the element whose attribute is to be read |
| Attribut | Name of the attribut (Column name) |
Example
ElemAttributeDimElement("Products";"T-Serie";"Productgroup")
Returns the name of the product group, which is related to the element "T-Serie" in the dimension "Products"
If one of the parameters is invalid (dimension doesn't exist, element doesn't exist, attribute doesn't exist), this is indicated by the return value. For the significance of the possible return values, see Constants and return values.
