Excel Client:Functions (Formulas): Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
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 [[Excel_Client:Constants_and_Return_Values|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. | 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 [[Excel_Client:Constants_and_Return_Values|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. | ||
Revision as of 08:30, 7 May 2010
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])
