Excel Client :Constants and Return Values

By formula errors (wrong parameters, syntax, etc.) or problems with the execution/evaluation of a report created in Microsoft Excel, the integrated CoPlanner Excel client functions will return constants that are used for troubleshooting.

Below you can find a list of CoPlanner integrated Excel client constants:

Constant	Meaning
N/A	Means „Not available“. You find the info dialogue at the login. It will be displayed if you don't have a connection to the Coplanner server.Z
N/P	Means „Not possible“. If the writing to the database, based on a CellRead formula is not possible, this constant will be returned to inform the user should that the input value was not take over into the database.
N/C	Means „Not connected“. It will be returned by CellRead formulas, if you don't have a connection to the CoPlanner server (no Login exists and a refresh (F9) was provoked)
NaN	Means „Not available Number“. This will be displayed on every refresh (F9) on CellRead formulas for the first step. If the update is finished and in one cell the constant is displayed, the value couldn't be loaded from the CoPlanner server because of a failure.
C.n.F.	Means „Cube not found“. It will be returned by CellRead formulas, if the specified object (Parameter 2) doesn't exist in the modell.
M.n.F.	Means „Measure not found“. It will be returned by CellRead formulas, if the specified measure (Parameter 2) doesn't exist in the modell.
D.n.F.	Means „Dimension not found“. It will be returned by CellRead formulas, if the spefified dimension (one of the slicer ) doesn't exist in the modell or if the there is no link between the dimension and the specified object (Paramter 1).
P.n.F.	Means „Plan not found“. It will be returned by CellRead formulas, if the specified plan (Element in the slicer) doesn't exist in the modell. For Example: CellRead (...; "Plan: = ABC" ...). Also in the ElemSelect function is it displayed to the user that the selected plan does not exist.
A.n.F.	Means „Attribut not found“. It will be returned by the function ElemAttribut, it the speficied attribut doesn't exist in the dimension. For Example: ElemAttribut(„Products“;“Racing bike“;“motorization details“.
F.n.F.	Means „Filter not found“. It will be returned by CellRead formulas, if the specified filter for the object isn't valid. For Example: CellRead(„Revenues“;“Sales“;“expenses-distribution-sheet-structur:=expenses-distribution-sheet-structur“;.)
E.n.F.	Means „Element not found“. It will be returned by CellRead formulas, if the specified dimension element is not part of the dimension. For Example: CellRead(…;„Time:=Aktivsside“;…).