Excel Client:ElemAttribut: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==ElemAttribut(DimensionName, Element, Attribut) | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>ElemAttribut(DimensionName, Element, Attribut)</span> | |||
This [[Excel_Client:Functions_(Formulas)|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). | This [[Excel_Client:Functions_(Formulas)|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). | ||
{| class="wikitable" width={{{breite|80%}}} | |||
|- {{Tabellentitel}} | |||
{| class="wikitable" width=" | | width="150px"|Parameter | ||
| Description | |||
|- | |- | ||
| | |DimensionName | ||
|The name of the dimension that contains the element. | |The name of the dimension that contains the element. | ||
|- | |- | ||
| | |Element | ||
|The element whose attribute is to be read. | |The element whose attribute is to be read. | ||
|- | |- | ||
| | |Attribut | ||
|The name of the attribute (column name). | |The name of the attribute (column name). | ||
|} | |} | ||
==Example == | |||
<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.) | |||
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 [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]. | 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 [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]. | ||
Revision as of 10:26, 24 May 2012
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.
