Admin: Created page with "==Function== ElemAttributeDimElement(DimensionName, ElementName, Attribut) Through this [[Excel_Client:Funct..."

2015-04-20T14:53:59Z

Created page with "==Function== ElemAttributeDimElement(DimensionName, ElementName, Attribut) Through this [[Excel_Client:Funct..."

New page

==[[Excel_Client:Functions_(Formulas)|Function]]==

ElemAttributeDimElement(DimensionName, ElementName, Attribut)

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.

{| class="wikitable" width={{{breite|80%}}}
|- {{Tabellentitel}}
| width="150px"|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 [[Excel_Client_:Constants and Return Values|Constants and return values]].

__NOEDITSECTION__
[[Category:Excel_Client_Formulas|ElemAttributeDimElement]]
[[de:Excel_Client_2.0:ElemAttributeDimElement]]

Excel Client:ElemAttributeDimElement - Revision history

Admin: Created page with "==Function== ElemAttributeDimElement(DimensionName, ElementName, Attribut) Through this [[Excel_Client:Funct..."