Excel Client:ElemAttributDimElement: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
Created page with "==Function== <span {{CoPFormel}}>ElemAttributeDimElement(DimensionName, ElementName, Attribut)</span> Through this [[Excel_Client:Funct..."
 
Undo revision 15240 by Admin (talk)
 
(One intermediate revision by the same user not shown)
(No difference)

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.