Excel Client:Functions (Formulas)

The CoPlanner Excel Client adds the following specific CoPlanner functions to the existing Excel functions. If a formula or function created by you does not return the expected value, please refer to the section on Constants and Return Values for a list and a description of the values that are returned by the system for the purpose of error correction in the case of incorrect parameter specifications.

• ElemChildName(Dimension, StartElement, Index)
• ElemChildCount(Dimension, StartElement)
• ElemIsChild(Dimension, Child, Parent)
• ElemIsAncle(Dimension, Ancle, Parent)
• ElemHasChild(Dimension, Element)
• ElemParent(Dimension, Element)
• ElemFirstSibling(Dimension, Element)
• ElemLastSibling(Dimension, Element)
• ElemFirstChild(Dimension, Element)
• ElemLastChild(Dimension, Element)
• ElemIndex(Dimension, Element)
• ElemPrevMember(Dimension, Element)
• ElemNextMember(Dimension, Element)
• CopExpression(Expression)
• GetServerName()
• GetUserName()
• DrillElement(DimensionName, ElementName, OnAxe, Open)
• Logon()
• ElemSelect(Dimension, Element)
• CellRead(CubeName, MeasureName, [Slicer1], …, [Slicer15])
• ElemAttribut(DimensionName, Element, Attribut)
• MeasureByIndex(ObjectName, Index)
• CopRun(Executable, [Parameter1], …, [Parameter10])
• CellWrite(Value, CubeName, Measure, [Slicer1], …, [Slicer15])
• CellDelete(CubeName, Measure, [Slicer1], …, [Slicer15])