Excel Client:ElemSelect - Revision history

Admin at 12:58, 15 April 2014

2014-04-15T12:58:26Z

← Older revision		Revision as of 14:58, 15 April 2014
Line 18:		Line 18:

	==Example ==		==Example ==
	<span {{CoPFormel}}>ElemSelect(~~„Produkte“~~;~~„Rennräder“~~)</span><br>		<span {{CoPFormel}}>ElemSelect("Produkte";"Rennräder")</span><br>
	returns Rennräder		returns Rennräder

	The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See [[Excel_Client:Constants_and_Return_Values\|Constants and Return Values]]).		The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See [[Excel_Client:Constants_and_Return_Values\|Constants and Return Values]]).

	<span {{CoPFormel}}>ElemSelect(~~„Plan“~~;~~„Budget 2006“~~)</span><br>		<span {{CoPFormel}}>ElemSelect("Plan";"Budget 2006")</span><br>
	returns „Budget 2006“		returns „Budget 2006“

Admin at 08:45, 24 May 2012

2012-05-24T08:45:24Z

← Older revision		Revision as of 10:45, 24 May 2012
Line 1:		Line 1:
	==ElemSelect(Dimension, Element)==		==[[Excel_Client:Functions_(Formulas)\|Function]]==

			<span {{CoPFormel}}>ElemSelect(Dimension, Element)</span>

	A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see [[Excel_Client:Transferring_a_Report_into_Excel#Changing_a_filter\|Editing a Filter]]). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see [[Excel_Client:Constants_and_Return_Values\|Constants and Return Values]]).		A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see [[Excel_Client:Transferring_a_Report_into_Excel#Changing_a_filter\|Editing a Filter]]). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see [[Excel_Client:Constants_and_Return_Values\|Constants and Return Values]]).

	~~===Parameter===~~		{\| class="wikitable" width={{{breite\|80%}}}
			\|- {{Tabellentitel}}
	{\| class="wikitable" width={{{breite\|50%}}}		\| width="150px"\|Parameter
	\|-		\| Description
	\|width="~~210pt~~" ~~style=background~~-~~color:#f6f6f6~~ \|~~'''~~Dimension~~'''~~		\|-
			\|Dimension
	\|The name of the dimension.		\|The name of the dimension.
	\|-		\|-
	\|~~style=background-color:#f6f6f6 \|'''~~Element ~~'''~~		\|Element
	\|The selected element.		\|The selected element.
	\|}		\|}

			==Example ==
	===Example ===		<span {{CoPFormel}}>ElemSelect(„Produkte“;„Rennräder“)</span><br>
			returns Rennräder
	~~{\| class="wikitable" width=~~{{~~{breite\|50%~~}}}
	\|-
	~~\|width="210pt" style=background-color:#f6f6f6 \|'''Function'''~~
	~~\|style=background-color:#f6f6f6 \|'''Result '''~~
	\|-
	\|ElemSelect(„Produkte“;„Rennräder“)
	\|Rennräder
	\|}


	The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See [[Excel_Client:Constants_and_Return_Values\|Constants and Return Values]]).		The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See [[Excel_Client:Constants_and_Return_Values\|Constants and Return Values]]).

			<span {{CoPFormel}}>ElemSelect(„Plan“;„Budget 2006“)</span><br>
			returns „Budget 2006“

	~~===Example ===~~

	~~{\| class="wikitable" width={{{breite\|50%}}}~~
	~~\|- {{Tabellentitel}}~~
	~~\|width="210pt" \|Function~~
	~~\|Result~~
	\|-
	~~\|ElemSelect(„Plan“;„Budget 2006“)~~
	~~\|„Budget 2006“~~
	\|}


	~~__NOTOC__~~
	__NOEDITSECTION__		__NOEDITSECTION__
	[[Category:Excel_Client_Formulas\|ElemSelect]]		[[Category:Excel_Client_Formulas\|ElemSelect]]
	[[de:Excel_Client:ElemSelect]]		[[de:Excel_Client:ElemSelect]]

Admin at 07:19, 6 March 2012

2012-03-06T07:19:47Z

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

	{\| ~~style=cellspacing="1" cellpadding="5" border~~="1" width={{{breite\|50%}}}		{\| class="wikitable" width={{{breite\|50%}}}
	\|-		\|-
	\|width="210pt" style=background-color:#f6f6f6 \|'''Dimension'''		\|width="210pt" style=background-color:#f6f6f6 \|'''Dimension'''
	\|The name of the dimension.		\|The name of the dimension.
Line 17:		Line 17:
	===Example ===		===Example ===

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

	{\| ~~style=cellspacing="1" cellpadding="5" border~~="1" width={{{breite\|50%}}}		{\| class="wikitable" width={{{breite\|50%}}}
	\|-		\|- {{Tabellentitel}}
	\|width="210pt" ~~style=background-color:#f6f6f6~~ \|~~'''~~Function~~'''~~		\|width="210pt" \|Function
	\|~~style=background-color:#f6f6f6 \|'''~~Result~~'''~~		\|Result
	\|-		\|-
	\|ElemSelect(„Plan“;„Budget 2006“)		\|ElemSelect(„Plan“;„Budget 2006“)

Admin: Created page with '==ElemSelect(Dimension, Element)== A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open …'

2010-05-07T06:00:06Z

Created page with '==ElemSelect(Dimension, Element)== A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open …'

New page

==ElemSelect(Dimension, Element)==

A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see [[Excel_Client:Transferring_a_Report_into_Excel#Changing_a_filter|Editing a Filter]]). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]).

===Parameter===

{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="210pt" style=background-color:#f6f6f6 |'''Dimension'''
|The name of the dimension.
|-
|style=background-color:#f6f6f6 |'''Element '''
|The selected element.
|}

===Example ===

{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="210pt" style=background-color:#f6f6f6 |'''Function'''
|style=background-color:#f6f6f6 |'''Result '''
|-
|ElemSelect(„Produkte“;„Rennräder“)
|Rennräder
|}

The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]).

===Example ===

{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="210pt" style=background-color:#f6f6f6 |'''Function'''
|style=background-color:#f6f6f6 |'''Result'''
|-
|ElemSelect(„Plan“;„Budget 2006“)
|„Budget 2006“
|}

__NOTOC__
__NOEDITSECTION__
[[Category:Excel_Client_Formulas|ElemSelect]]
[[de:Excel_Client:ElemSelect]]