Excel Client:Functions (Formulas): Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 28: | Line 28: | ||
:*[[Excel Client:GetUserName|GetUserName()]] | :*[[Excel Client:GetUserName|GetUserName()]] | ||
:*[[Excel Client:MeasureByIndex|MeasureByIndex(ObjectName, Index)]] | :*[[Excel Client:MeasureByIndex|MeasureByIndex(ObjectName, Index)]] | ||
:*[[Excel Client:MeasureSelect| | :*[[Excel Client:MeasureSelect|MeasureSelect(ObjectName, Index)]] | ||
Revision as of 15:36, 15 April 2015
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.
- CellRead(CubeName, MeasureName, [Slicer1], …, [Slicer15])
- CopExpression(Expression)
- DimSize(DimensionName)
- DrillElement(DimensionName, ElementName, OnAxe, Open)
- ElemAttribut(DimensionName, Element, Attribut)
- ElemAttributDimElement(DimensionName, ElementName, Attribut)
- ElemChildCount(Dimension, StartElement)
- ElemChildName(Dimension, StartElement, Index)
- ElemChildIndex(DimensionName, ParentElement, ChildElement)
- ElemChildName(DimensionName, ElementName, Index)
- ElemFirstSibling(Dimension, Element)
- ElemHasChild(Dimension, Element)
- ElemIsChild(Dimension, Child, Parent)
- ElemIsSubElement(DimensionName, ParentElement, ChildElement)
- ElemLastSibling(Dimension, Element)
- ElemMultiSelect(DimensionName, Elemente)
- ElemNextMember(Dimension, ElementName)
- ElemParent(Dimension, Element)
- ElemPrevMember(Dimension, Element)
- ElemSelect(Dimension, Element)
- GetFilter(BlattName, FilterName)
- GetFilterAlias(BlattName, FilterName, Alias)
- GetFilterCirteria(BlattName, FilterName)
- GetFilterOperator(BlattName, FilterName)
- GetServerName()
- GetUserName()
- MeasureByIndex(ObjectName, Index)
- MeasureSelect(ObjectName, Index)
