Excel Client:CellRead: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
|||
| (8 intermediate revisions by the same user not shown) | |||
| 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. | ||
{| class="wikitable" width={{{breite|80%}}} | |||
|- {{Tabellentitel}} | |||
{| | | width="150px"|Parameter | ||
| Description | |||
|- | |- | ||
| | |CubeName | ||
|The name of the object whose data must be read. | |The name of the object whose data must be read. | ||
|- | |- | ||
| | |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. | ||
|- | |- | ||
| | |SlicerX | ||
|Filter setting in the format “Dimension:=Element”. | |Filter setting in the format “Dimension:=Element”. | ||
|} | |} | ||
==Example == | |||
<span {{CoPFormel}}>CellRead("Umsatzerloese_PLAN"; "Umsatz"; "Zeit:=2005"; "Produkte:=Rennräder"; "PC/KST:=Verwaltung")</span><br> | |||
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]]: | |||
<span {{CoPFormel}}>CellRead("Umsatzerloese_PLAN"; "Umsatz"; "Zeit:="&$B$1; "Produkte:="&$B$2; "PC/KST:=" &$B$3)</span> | |||
Example with absolute cell references based on filter settings that can be performed in the report by the user via ElemSelect: | |||
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. | ==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. | |||
The following filter operators are available: | The following filter operators are available: | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- {{Tabellentitel}} | ||
|width="200pt" | |width="200pt" |Filter operators | ||
| | |Description | ||
|- | |- | ||
|:= | |:= | ||
| 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. | ||
|} | |} | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|CellRead]] | [[Category:Excel_Client_Formulas|CellRead]] | ||
[[de:Excel_Client:CellRead]] | [[de:Excel_Client:CellRead]] | ||
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. |
