Excel Client:CellRead: Difference between revisions
No edit summary |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
|- {{Tabellentitel}} | |- {{Tabellentitel}} | ||
| width="150px"|Parameter | | width="150px"|Parameter | ||
| | | Description | ||
|- | |- | ||
|CubeName | |CubeName | ||
| Line 21: | Line 21: | ||
==Example == | ==Example == | ||
<span {{CoPFormel}}>CellRead( | <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 | ||
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( | <span {{CoPFormel}}>CellRead("Umsatzerloese_PLAN"; "Umsatz"; "Zeit:="&$B$1; "Produkte:="&$B$2; "PC/KST:=" &$B$3)</span> | ||
==Filteroperators== | ==Filteroperators== | ||
Latest revision as of 10:11, 21 May 2015
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. |
