Excel Client:CellRead

Function

CellRead(CubeName, MeasureName, [Slicer1], …, [Slicer15])

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	Description
CubeName	The name of the object whose data must be read.
MeasureName	The name of the measure (field) whose value must be read out.
SlicerX	Filter setting in the format “Dimension:=Element”.

Example

CellRead("Umsatzerloese_PLAN"; "Umsatz"; "Zeit:=2005"; "Produkte:=Rennräder"; "PC/KST:=Verwaltung")
returns 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 ElemSelect: CellRead(„Umsatzerloese_PLAN“; „Umsatz“; „Zeit:=“&$B$1; „Produkte:=“&$B$2; „PC/KST:=“ &$B$3)

Filteroperators

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. The following filter operators are available:

Filter operators	Description
:=	Displays selected element and all elements below it.
$=	Displays only values of this dimension element.
!=	Displays all values except that of the selected filter element.
>>	Only in time dimensions: Displays all elements that are larger.
<<	Only in time dimensions: Displays all elements that are smaller.
>=	Only in time dimensions: Displays the selected element and all elements that are larger.
<=	Only in time dimensions: Displays the selected element and all elements that are smaller.