Excel Client:Functions (Formulas): Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 25: | Line 25: | ||
:*[[Excel Client:MeasureByIndex|MeasureByIndex(ObjectName, Index)]] | :*[[Excel Client:MeasureByIndex|MeasureByIndex(ObjectName, Index)]] | ||
:*[[Excel Client:CopRun|CopRun(Executable, <nowiki>[</nowiki>Parameter1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Parameter10<nowiki>]</nowiki>)]] | :*[[Excel Client:CopRun|CopRun(Executable, <nowiki>[</nowiki>Parameter1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Parameter10<nowiki>]</nowiki>)]] | ||
Revision as of 16:43, 16 April 2012
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])
