Excel Client:ElemAttribut: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 21: | Line 21: | ||
==Example == | ==Example == | ||
<span {{CoPFormel}}>ElemAttribut( | <span {{CoPFormel}}>ElemAttribut("Produkte";"Bikes";"vs_key")</span><br> | ||
returns 4001 (This value does not necessarily correspond to your model, and the Products dimension of your model does not necessarily contain the attribute vs_key.) | returns 4001 (This value does not necessarily correspond to your model, and the Products dimension of your model does not necessarily contain the attribute vs_key.) | ||
Latest revision as of 10:13, 21 May 2015
Function
ElemAttribut(DimensionName, Element, Attribut)
This function can be used to read an attribute of a dimension element (Dimension Manager, Windows Client). This function is volatile (it is executed every time the worksheet is calculated).
| Parameter | Description |
| DimensionName | The name of the dimension that contains the element. |
| Element | The element whose attribute is to be read. |
| Attribut | The name of the attribute (column name). |
Example
ElemAttribut("Produkte";"Bikes";"vs_key")
returns 4001 (This value does not necessarily correspond to your model, and the Products dimension of your model does not necessarily contain the attribute vs_key.)
If one of the parameters is invalid (dimension not found, element not found, attribute not found), this will be indicated by the return value. For the meanings of the return values that may be displayed, please refer to Constants and Return Values.
