Excel Client:Functions (Formulas): Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
VisualWikitext
Created page with '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 v…'
 
Undo revision 15239 by Admin (talk)
 
(6 intermediate revisions by the same user not shown)
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 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, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>)]]
:*[[Excel Client:CopExpression|CopExpression(Expression)]]
:*[[Excel Client:DimSize|DimSize(DimensionName)]]
:*[[Excel Client:DrillElement|DrillElement(DimensionName, ElementName, OnAxe, Open)]]
:*[[Excel Client:ElemAttribut|ElemAttribut(DimensionName, Element, Attribut)]]
:*[[Excel Client:ElemAttributDimElement|ElemAttributDimElement(DimensionName, ElementName, Attribut)]]
:*[[Excel Client:ElemChildCount|ElemChildCount(Dimension, StartElement)]]
:*[[Excel Client:ElemChildName|ElemChildName(Dimension, StartElement, Index)]]
:*[[Excel Client:ElemChildName|ElemChildName(Dimension, StartElement, Index)]]
:*[[Excel Client:ElemChildCount|ElemChildCount(Dimension, StartElement)]]
:*[[Excel Client:ElemChildIndex|ElemChildIndex(DimensionName, ParentElement, ChildElement)]]
:*[[Excel Client:ElemChildName|ElemChildName(DimensionName, ElementName, Index)]]
:*[[Excel Client:ElemFirstSibling|ElemFirstSibling(Dimension, Element)]]
:*[[Excel Client:ElemHasChild|ElemHasChild(Dimension, Element)]]
:*[[Excel Client:ElemIsChild|ElemIsChild(Dimension, Child, Parent)]]
:*[[Excel Client:ElemIsChild|ElemIsChild(Dimension, Child, Parent)]]
:*[[Excel Client:ElemIsAncle|ElemIsAncle(Dimension, Ancle, Parent)]]
:*[[Excel Client:ElemIsSubElement|ElemIsSubElement(DimensionName, ParentElement, ChildElement)]]
:*[[Excel Client:ElemHasChild|ElemHasChild(Dimension, Element)]]
:*[[Excel Client:ElemLastSibling|ElemLastSibling(Dimension, Element)]]
:*[[Excel Client:ElemMultiSelect|ElemMultiSelect(DimensionName, Elemente)]]
:*[[Excel Client:ElemNextMember|ElemNextMember(Dimension, ElementName)]]
:*[[Excel Client:ElemParent|ElemParent(Dimension, Element)]]
:*[[Excel Client:ElemParent|ElemParent(Dimension, Element)]]
:*[[Excel Client:ElemFirstSibling|ElemFirstSibling(Dimension, Element)]]
:*[[Excel Client:ElemLastSibling|ElemLastSibling(Dimension, Element)]]
:*[[Excel Client:ElemFirstChild|ElemFirstChild(Dimension, Element)]]
:*[[Excel Client:ElemLastChild|ElemLastChild(Dimension, Element)]]
:*[[Excel Client:ElemIndex|ElemIndex(Dimension, Element)]]
:*[[Excel Client:ElemPrevMember|ElemPrevMember(Dimension, Element)]]
:*[[Excel Client:ElemPrevMember|ElemPrevMember(Dimension, Element)]]
:*[[Excel Client:ElemNextMember|ElemNextMember(Dimension, Element)]]
:*[[Excel Client:ElemSelect|ElemSelect(Dimension, Element)]]
:*[[Excel Client:CopExpression|CopExpression(Expression)]]
:*[[Excel Client:GetFilter|GetFilter(BlattName, FilterName)]]
:*[[Excel Client:GetFilterAlias|GetFilterAlias(BlattName, FilterName, Alias)]]
:*[[Excel Client:GetFilterCriteria|GetFilterCirteria(BlattName, FilterName)]]
:*[[Excel Client:GetFilterOperator|GetFilterOperator(BlattName, FilterName)]]
:*[[Excel Client:GetServerName()|GetServerName()]]
:*[[Excel Client:GetServerName()|GetServerName()]]
:*[[Excel Client:GetUserName|GetUserName()]]
:*[[Excel Client:GetUserName|GetUserName()]]
:*[[Excel Client:DrillElement|DrillElement(DimensionName, ElementName, OnAxe, Open)]]
:*[[Excel Client:Logon|Logon()]]
:*[[Excel Client:ElemSelect|ElemSelect(Dimension, Element)]]
:*[[Excel Client:CellRead|CellRead(CubeName, MeasureName, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>)]]
:*[[Excel Client:ElemAttribut|ElemAttribut(DimensionName, Element, Attribut)]]
:*[[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:MeasureSelect|MeasureSelect(ObjectName, Index)]]
:*[[Excel Client:CellWrite|CellWrite(Value, CubeName, Measure, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>)]]
 
:*[[Excel Client:CellDelete|CellDelete(CubeName, Measure, <nowiki>[</nowiki>Slicer1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Slicer15<nowiki>]</nowiki>)]]




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.

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Excel_Client:Functions_(Formulas)&oldid=15243"