Excel Client:CellRead: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==[[Excel_Client:Functions_(Formulas)|Function]]== | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>CellRead(CubeName, MeasureName, | <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 | 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. | ||
|- | |- | ||
| | |Filter | ||
|Filter setting in the format “Dimension:=Element”. | |Filter setting in the format “Dimension:=Element”. | ||
|} | |} | ||
Revision as of 10:05, 21 May 2015
Function
CellRead(CubeName, MeasureName, Filter; ...)
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.
| 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. |
| Filter | 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. |
