Excel Client:ElemAttribut: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
===Parameter=== | ===Parameter=== | ||
{| | {| class="wikitable" width="50%" | ||
|- | |- | ||
|width="200pt" style=background-color:#f6f6f6 |'''DimensionName''' | |width="200pt" style=background-color:#f6f6f6 |'''DimensionName''' | ||
| Line 20: | Line 20: | ||
===Example === | ===Example === | ||
{| | {| class="wikitable" width="50%" | ||
|- {{Tabellentitel}} | |||
|width="200pt" | |width="200pt" |Function | ||
| | |Result | ||
|- | |- | ||
|ElemAttribut(“Produkte”;”Bikes”;”vs_key”) | |ElemAttribut(“Produkte”;”Bikes”;”vs_key”) | ||
Revision as of 09:44, 6 March 2012
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
| 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
| Function | Result |
| ElemAttribut(“Produkte”;”Bikes”;”vs_key”) | 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.
