Excel Client:ElemSelect

Function

ElemSelect(Dimension, Element)

A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see Editing a Filter). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see Constants and Return Values).

Parameter	Description
Dimension	The name of the dimension.
Element	The selected element.

Example

ElemSelect("Produkte";"Rennräder")
returns Rennräder

The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See Constants and Return Values).

ElemSelect("Plan";"Budget 2006")
returns „Budget 2006“