Excel Client:Functions (Formulas): Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
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. | ||
:*[[Excel Client:CellRead|CellRead(CubeName, MeasureName, | :*[[Excel Client:CellRead|CellRead(CubeName, MeasureName, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>)]] | ||
:*[[Excel Client:CopExpression|CopExpression(Expression)]] | :*[[Excel Client:CopExpression|CopExpression(Expression)]] | ||
:*[[Excel Client:DimSize|DimSize(DimensionName)]] | :*[[Excel Client:DimSize|DimSize(DimensionName)]] | ||
:*[[Excel Client:DrillElement|DrillElement(DimensionName, ElementName, OnAxe, Open)]] | :*[[Excel Client:DrillElement|DrillElement(DimensionName, ElementName, OnAxe, Open)]] | ||
:*[[Excel Client:ElemAttribut|ElemAttribut(DimensionName, Element, | :*[[Excel Client:ElemAttribut|ElemAttribut(DimensionName, Element, Attribut)]] | ||
:*[[Excel Client:ElemAttributDimElement|ElemAttributDimElement(DimensionName, ElementName, | :*[[Excel Client:ElemAttributDimElement|ElemAttributDimElement(DimensionName, ElementName, Attribut)]] | ||
:*[[Excel Client:ElemChildCount|ElemChildCount(Dimension, StartElement)]] | :*[[Excel Client:ElemChildCount|ElemChildCount(Dimension, StartElement)]] | ||
:*[[Excel Client:ElemChildName|ElemChildName(Dimension, StartElement, Index)]] | :*[[Excel Client:ElemChildName|ElemChildName(Dimension, StartElement, Index)]] | ||
| Line 22: | Line 22: | ||
:*[[Excel Client:ElemSelect|ElemSelect(Dimension, Element)]] | :*[[Excel Client:ElemSelect|ElemSelect(Dimension, Element)]] | ||
:*[[Excel Client:GetFilter|GetFilter(BlattName, FilterName)]] | :*[[Excel Client:GetFilter|GetFilter(BlattName, FilterName)]] | ||
:*[[Excel Client:GetFilterAlias|GetFilterAlias(BlattName, FilterName, | :*[[Excel Client:GetFilterAlias|GetFilterAlias(BlattName, FilterName, Alias)]] | ||
:*[[Excel Client:GetFilterCriteria|GetFilterCirteria(BlattName, FilterName)]] | :*[[Excel Client:GetFilterCriteria|GetFilterCirteria(BlattName, FilterName)]] | ||
:*[[Excel Client:GetFilterOperator|GetFilterOperator(BlattName, FilterName)]] | :*[[Excel Client:GetFilterOperator|GetFilterOperator(BlattName, FilterName)]] | ||
Latest revision as of 10:11, 21 May 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)
