Excel Client:CellRead - Revision history

Admin: Undo revision 15238 by Admin (talk)

2015-05-21T08:11:55Z

Undo revision 15238 by Admin (talk)

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

	<span {{CoPFormel}}>CellRead(CubeName, MeasureName, ~~Filter; ...~~)</span>		<span {{CoPFormel}}>CellRead(CubeName, MeasureName, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>)</span>

	The CellRead function loads data from the CoPlanner server corresponding to the object, the measure (field), and the filter. The ~~filter is~~ optional. This means that the parameter can be filled if desired, but that filling the parameter is not mandatory.		The CellRead function loads data from the CoPlanner server corresponding to the object, the measure (field), and the slicer (filter). The filters Slicer1 through Slicer9 are optional. This means that the parameter can be filled if desired, but that filling the parameter is not mandatory.

	{\| class="wikitable" width={{{breite\|80%}}}		{\| class="wikitable" width={{{breite\|80%}}}
Line 16:		Line 16:
	\|The name of the measure (field) whose value must be read out.		\|The name of the measure (field) whose value must be read out.
	\|-		\|-
	\|~~Filter~~		\|SlicerX
	\|Filter setting in the format “Dimension:=Element”.		\|Filter setting in the format “Dimension:=Element”.
	\|}		\|}

Admin at 08:05, 21 May 2015

2015-05-21T08:05:06Z

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

	<span {{CoPFormel}}>CellRead(CubeName, MeasureName, ~~<nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>~~)</span>		<span {{CoPFormel}}>CellRead(CubeName, MeasureName, Filter; ...)</span>

	The CellRead function loads data from the CoPlanner server corresponding to the object, the measure (field), and the ~~slicer (~~filter). The ~~filters Slicer1 through Slicer9 are~~ optional. This means that the parameter can be filled if desired, but that filling the parameter is not mandatory.		The CellRead function loads data from the CoPlanner server corresponding to the object, the measure (field), and the filter. The filter is optional. This means that the parameter can be filled if desired, but that filling the parameter is not mandatory.

	{\| class="wikitable" width={{{breite\|80%}}}		{\| class="wikitable" width={{{breite\|80%}}}
Line 16:		Line 16:
	\|The name of the measure (field) whose value must be read out.		\|The name of the measure (field) whose value must be read out.
	\|-		\|-
	\|~~SlicerX~~		\|Filter
	\|Filter setting in the format “Dimension:=Element”.		\|Filter setting in the format “Dimension:=Element”.
	\|}		\|}

Admin at 12:59, 15 April 2014

2014-04-15T12:59:41Z

← Older revision		Revision as of 13:59, 15 April 2014
Line 25:		Line 25:

	Example with absolute cell references based on filter settings that can be performed in the report by the user via [[Excel_Client:ElemSelect\|ElemSelect]]:		Example with absolute cell references based on filter settings that can be performed in the report by the user via [[Excel_Client:ElemSelect\|ElemSelect]]:
	<span {{CoPFormel}}>CellRead(~~„Umsatzerloese_PLAN“~~; ~~„Umsatz“~~; ~~„Zeit~~:=“&$B$1; ~~„Produkte~~:=“&$B$2; ~~„PC~~/KST:=“ &$B$3)</span>		<span {{CoPFormel}}>CellRead("Umsatzerloese_PLAN"; "Umsatz"; "Zeit:="&$B$1; "Produkte:="&$B$2; "PC/KST:=" &$B$3)</span>

	==Filteroperators==		==Filteroperators==

Admin at 12:59, 15 April 2014

2014-04-15T12:59:01Z

← Older revision		Revision as of 13:59, 15 April 2014
Line 21:		Line 21:

	==Example ==		==Example ==
	<span {{CoPFormel}}>CellRead(~~„Umsatzerloese_PLAN“~~; ~~„Umsatz“~~; ~~„Zeit~~:=~~2005“~~; ~~„Produkte~~:=~~Rennräder“~~; ~~„PC~~/KST:=~~Verwaltung“~~)</span><br>		<span {{CoPFormel}}>CellRead("Umsatzerloese_PLAN"; "Umsatz"; "Zeit:=2005"; "Produkte:=Rennräder"; "PC/KST:=Verwaltung")</span><br>
	returns Depending on value; corresponding to parameters		returns Depending on value; corresponding to parameters

Admin at 08:19, 24 May 2012

2012-05-24T08:19:29Z

← Older revision		Revision as of 09:19, 24 May 2012
Line 8:		Line 8:
	\|- {{Tabellentitel}}		\|- {{Tabellentitel}}
	\| width="150px"\|Parameter		\| width="150px"\|Parameter
	\| ~~Beschreibung~~		\| Description
	\|-		\|-
	\|CubeName		\|CubeName

Admin at 08:17, 24 May 2012

2012-05-24T08:17:33Z

← Older revision		Revision as of 09:17, 24 May 2012
Line 1:		Line 1:
	==CellRead(CubeName, MeasureName, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>) ==		==[[Excel_Client:Functions_(Formulas)\|Function]]==

			<span {{CoPFormel}}>CellRead(CubeName, MeasureName, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>)</span>

	The CellRead function loads data from the CoPlanner server corresponding to the object, the measure (field), and the slicer (filter). The filters Slicer1 through Slicer9 are optional. This means that the parameter can be filled if desired, but that filling the parameter is not mandatory.		The CellRead function loads data from the CoPlanner server corresponding to the object, the measure (field), and the slicer (filter). The filters Slicer1 through Slicer9 are optional. This means that the parameter can be filled if desired, but that filling the parameter is not mandatory.

	~~===Parameter===~~		{\| class="wikitable" width={{{breite\|80%}}}
			\|- {{Tabellentitel}}
	{\| class="wikitable" width={{{breite\|50%}}}		\| width="150px"\|Parameter
			\| Beschreibung
	\|-		\|-
	\|~~width="200pt" style=background-color:#f6f6f6 \|'''~~CubeName~~'''~~		\|CubeName
	\|The name of the object whose data must be read.		\|The name of the object whose data must be read.
	\|-		\|-
	\|~~style=background-color:#f6f6f6 \|'''~~MeasureName ~~'''~~		\|MeasureName
	\|The name of the measure (field) whose value must be read out.		\|The name of the measure (field) whose value must be read out.
	\|-		\|-
	\|~~style=background-color:#f6f6f6 \|'''~~SlicerX~~'''~~		\|SlicerX
	\|Filter setting in the format “Dimension:=Element”.		\|Filter setting in the format “Dimension:=Element”.
	\|}		\|}

			==Example ==
	===Example ===		<span {{CoPFormel}}>CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=2005“; „Produkte:=Rennräder“; „PC/KST:=Verwaltung“)</span><br>
			returns Depending on value; corresponding to parameters
	~~{\| class="wikitable" width=~~{{~~{breite\|50%}~~}}
	\|-
	~~\|width="200pt" style=background-color:#f6f6f6 \|'''Function'''~~
	~~\|style=background-color:#f6f6f6 \|'''Result '''~~
	\|-
	\|CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=2005“; „Produkte:=Rennräder“; „PC/KST:=Verwaltung“)
	\|Depending on value; corresponding to parameters
	\|}


	Example with absolute cell references based on filter settings that can be performed in the report by the user via [[Excel_Client:ElemSelect\|ElemSelect]]:		Example with absolute cell references based on filter settings that can be performed in the report by the user via [[Excel_Client:ElemSelect\|ElemSelect]]:
			<span {{CoPFormel}}>CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=“&$B$1; „Produkte:=“&$B$2; „PC/KST:=“ &$B$3)</span>

			==Filteroperators==
	~~===Example===~~

	~~{\| class="wikitable" width={{{breite\|50%}}}~~
	~~\|- {{Tabellentitel}}~~
	~~\|Function~~
	\|-
	~~\|CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=“&$B$1; „Produkte:=“&$B$2; „PC/KST:=“ &$B$3)~~
	\|}


	===Filteroperators===

	In this [[Excel_Client:Functions_(Formulas)\|function]], you can use filter operators together with the selected filter element in order to define your selection more closely. The filter operator will always be applied to the selected element.		In this [[Excel_Client:Functions_(Formulas)\|function]], you can use filter operators together with the selected filter element in order to define your selection more closely. The filter operator will always be applied to the selected element.
	The following filter operators are available:		The following filter operators are available:
Line 74:		Line 57:
	\|Only in time dimensions: Displays the selected element and all elements that are smaller.		\|Only in time dimensions: Displays the selected element and all elements that are smaller.
	\|}		\|}

	~~__NOTOC__~~

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

Admin at 06:59, 6 March 2012

2012-03-06T06:59:13Z

← Older revision		Revision as of 07:59, 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="200pt" style=background-color:#f6f6f6 \|'''CubeName'''		\|width="200pt" style=background-color:#f6f6f6 \|'''CubeName'''
Line 20:		Line 20:
	===Example ===		===Example ===

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

	{\| ~~style=cellspacing~~="~~1" cellpadding="5" border="1~~" width={{{breite\|50%}}}		{\| class="wikitable" width={{{breite\|50%}}}
	\|-		\|- {{Tabellentitel}}
	\|~~width="200pt" style=background-color:#f6f6f6 \|'''~~Function~~'''~~		\|Function
	\|-		\|-
	\|CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=“&$B$1; „Produkte:=“&$B$2; „PC/KST:=“ &$B$3)		\|CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=“&$B$1; „Produkte:=“&$B$2; „PC/KST:=“ &$B$3)
Line 48:		Line 48:
	The following filter operators are available:		The following filter operators are available:

	{\| ~~style=cellspacing="1" cellpadding~~="~~5" border="1~~" width={{{breite\|50%}}}		{\| class="wikitable" width={{{breite\|50%}}}
	\|-		\|- {{Tabellentitel}}
	\|width="200pt" ~~style=background-color:#f6f6f6~~ \|~~'''~~Filter operators~~'''~~		\|width="200pt" \|Filter operators
	\|~~'''~~Description ~~'''~~		\|Description
	\|-		\|-
	\|:=		\|:=

Admin at 06:15, 30 August 2011

2011-08-30T06:15:25Z

← Older revision		Revision as of 07:15, 30 August 2011
Line 43:		Line 43:


	===~~Filteroperatoren~~===		===Filteroperators===

	In this [[Excel_Client:Functions_(Formulas)\|function]], you can use filter operators together with the selected filter element in order to define your selection more closely. The filter operator will always be applied to the selected element.		In this [[Excel_Client:Functions_(Formulas)\|function]], you can use filter operators together with the selected filter element in order to define your selection more closely. The filter operator will always be applied to the selected element.

Admin at 06:18, 7 May 2010

2010-05-07T06:18:55Z

← Older revision		Revision as of 07:18, 7 May 2010
Line 30:		Line 30:


	Example with absolute cell references based on filter settings that can be performed in the report by the user via ElemSelect:		Example with absolute cell references based on filter settings that can be performed in the report by the user via [[Excel_Client:ElemSelect\|ElemSelect]]:


Line 45:		Line 45:
	===Filteroperatoren===		===Filteroperatoren===

	In this function, you can use filter operators together with the selected filter element in order to define your selection more closely. The filter operator will always be applied to the selected element.		In this [[Excel_Client:Functions_(Formulas)\|function]], you can use filter operators together with the selected filter element in order to define your selection more closely. The filter operator will always be applied to the selected element.
	The following filter operators are available:		The following filter operators are available:

Admin at 06:05, 7 May 2010

2010-05-07T06:05:04Z

← Older revision		Revision as of 07:05, 7 May 2010
Line 26:		Line 26:
	\|-		\|-
	\|CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=2005“; „Produkte:=Rennräder“; „PC/KST:=Verwaltung“)		\|CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=2005“; „Produkte:=Rennräder“; „PC/KST:=Verwaltung“)
	\|~~je nach Wert, entsprechend der Parameter~~		\|Depending on value; corresponding to parameters
	\|}		\|}