Excel Client:ElemAttributDimElement

From CoPlanner 10
Revision as of 15:46, 14 April 2015 by Admin (talk | contribs) (Created page with "==Function== <span {{CoPFormel}}>ElemAttributeDimElement(DimensionName, ElementName, Attribut)</span> Through this [[Excel_Client:Funct...")

(diff) ← Older revision | Approved revision (diff) | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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.