Excel Client:ElemAttribut - Revision history

Admin: Undo revision 15241 by Admin (talk)

2015-05-21T08:13:37Z

Undo revision 15241 by Admin (talk)

← Older revision		Revision as of 10:13, 21 May 2015
Line 1:		Line 1:
	==[[Excel_Client:Functions_(Formulas)\|Function]]==		==[[Excel_Client:Functions_(Formulas)\|Function]]==

	<span {{CoPFormel}}>ElemAttribut(DimensionName, Element, ~~AttributName~~)</span>		<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).
Line 16:		Line 16:
	\|The element whose attribute is to be read.		\|The element whose attribute is to be read.
	\|-		\|-
	\|~~AttributName~~		\|Attribut
	\|The name of the attribute (column name).		\|The name of the attribute (column name).
	\|}		\|}

Admin at 08:07, 21 May 2015

2015-05-21T08:07:26Z

← Older revision		Revision as of 10:07, 21 May 2015
Line 1:		Line 1:
	==[[Excel_Client:Functions_(Formulas)\|Function]]==		==[[Excel_Client:Functions_(Formulas)\|Function]]==

	<span {{CoPFormel}}>ElemAttribut(DimensionName, Element, ~~Attribut~~)</span>		<span {{CoPFormel}}>ElemAttribut(DimensionName, Element, AttributName)</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).
Line 16:		Line 16:
	\|The element whose attribute is to be read.		\|The element whose attribute is to be read.
	\|-		\|-
	\|~~Attribut~~		\|AttributName
	\|The name of the attribute (column name).		\|The name of the attribute (column name).
	\|}		\|}

Admin at 14:46, 15 April 2014

2014-04-15T14:46:06Z

← Older revision		Revision as of 16:46, 15 April 2014
Line 21:		Line 21:

	==Example ==		==Example ==
	<span {{CoPFormel}}>ElemAttribut(~~“Produkte”~~;~~”Bikes”~~;~~”vs_key”~~)</span><br>		<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.)

Admin at 08:26, 24 May 2012

2012-05-24T08:26:33Z

← Older revision		Revision as of 10:26, 24 May 2012
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).

	~~===Parameter===~~		{\| class="wikitable" width={{{breite\|80%}}}
			\|- {{Tabellentitel}}
	{\| class="wikitable" width="~~50%~~"		\| width="150px"\|Parameter
			\| Description
	\|-		\|-
	\|~~width="200pt" style=background-color:#f6f6f6 \|'''~~DimensionName~~'''~~		\|DimensionName
	\|The name of the dimension that contains the element.		\|The name of the dimension that contains the element.
	\|-		\|-
	\|~~style=background-color:#f6f6f6 \|'''~~Element ~~'''~~		\|Element
	\|The element whose attribute is to be read.		\|The element whose attribute is to be read.
	\|-		\|-
	\|~~style=background-color:#f6f6f6 \|'''~~Attribut~~'''~~		\|Attribut
	\|The name of the attribute (column name).		\|The name of the attribute (column name).
	\|}		\|}

			==Example ==
	===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.)
	~~{\| class="wikitable" width="50%"~~
	\|- {{~~Tabellentitel~~}}
	~~\|width="200pt" \|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 [[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]].

Admin at 07:44, 6 March 2012

2012-03-06T07:44:25Z

← Older revision		Revision as of 09:44, 6 March 2012
Line 5:		Line 5:
	===Parameter===		===Parameter===

	{\| ~~style=cellspacing~~="1" ~~cellpadding~~="~~5" border="1" width={{{breite\|~~50%~~}}}~~		{\| class="wikitable" width="50%"
	\|-		\|-
	\|width="200pt" style=background-color:#f6f6f6 \|'''DimensionName'''		\|width="200pt" style=background-color:#f6f6f6 \|'''DimensionName'''
Line 20:		Line 20:
	===Example ===		===Example ===

	{\| ~~style=cellspacing~~="1" ~~cellpadding~~="5" ~~border="1" width=~~{{~~{breite\|50%}~~}}		{\| class="wikitable" width="50%"
	\|-		\|- {{Tabellentitel}}
	\|width="200pt" ~~style=background-color:#f6f6f6~~ \|~~'''~~Function~~'''~~		\|width="200pt" \|Function
	\|~~style=background-color:#f6f6f6 \|'''~~Result ~~'''~~		\|Result
	\|-		\|-
	\|ElemAttribut(“Produkte”;”Bikes”;”vs_key”)		\|ElemAttribut(“Produkte”;”Bikes”;”vs_key”)

Admin at 06:19, 7 May 2010

2010-05-07T06:19:55Z

← Older revision		Revision as of 08:19, 7 May 2010
Line 1:		Line 1:
	==ElemAttribut(DimensionName, Element, Attribut)==		==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).		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).

	===Parameter===		===Parameter===
Line 29:		Line 29:
	\|}		\|}

	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.		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]].

	__NOEDITSECTION__		__NOEDITSECTION__
	[[Category:Excel_Client_Formulas\|ElemAttribut]]		[[Category:Excel_Client_Formulas\|ElemAttribut]]
	[[de:Excel_Client:ElemAttribut]]		[[de:Excel_Client:ElemAttribut]]

Admin: Created page with '==ElemAttribut(DimensionName, Element, Attribut)== This function can be used to read an attribute of a dimension element (Dimension Manager, Windows Client). This function is vo…'

2010-05-07T06:06:46Z

Created page with '==ElemAttribut(DimensionName, Element, Attribut)== This function can be used to read an attribute of a dimension element (Dimension Manager, Windows Client). This function is vo…'

New page

==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===

{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''DimensionName'''
|The name of the dimension that contains the element.
|-
|style=background-color:#f6f6f6 |'''Element '''
|The element whose attribute is to be read.
|-
|style=background-color:#f6f6f6 |'''Attribut'''
|The name of the attribute (column name).
|}

===Example ===

{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''Function'''
|style=background-color:#f6f6f6 |'''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.

__NOEDITSECTION__
[[Category:Excel_Client_Formulas|ElemAttribut]]
[[de:Excel_Client:ElemAttribut]]