Difference between revisions of "XLCubed MDX Calculation Support"

(Set functions)
Line 8: Line 8:
 
* <code>{ }</code> - braces
 
* <code>{ }</code> - braces
 
** Multiple members/tuples can be combined
 
** Multiple members/tuples can be combined
** [https://docs.microsoft.com/en-us/sql/mdx/range-mdx Range operator] <code> : </code> is supported
+
** Range operator <code> : </code> is supported [https://docs.microsoft.com/en-us/sql/mdx/range-mdx]
 
* Ancestors
 
* Ancestors
 
* Children
 
* Children

Revision as of 10:26, 20 July 2022

For some data sources that do not natively support MDX XLCubed can execute calculations on top of the source database.

Currently this is available for Fluence and Anaplan connection types.

Supported Functions

Set functions

  • { } - braces
    • Multiple members/tuples can be combined
    • Range operator  : is supported [1]
  • Ancestors
  • Children
  • Head
  • Item
  • LastPeriods
  • PeriodsToDate
  • Siblings
  • Subset
  • Tail

Member functions

  • Ancestor
  • ClosingPeriod
  • Cousin
  • CurrentMember
  • DefaultMember
  • Descendants
  • FirstMember
  • FirstSibling
  • Item
  • Lag
  • LastMember
  • LastSibling
  • Lead
  • Level
  • NextMember
  • OpeningPeriod
  • ParallelPeriod
  • Parent
  • PrevMember

Aggregation funtions

  • Aggregate
  • Avg
  • Count
  • Max
  • Min
  • Sum

Text functions

  • CStr
  • Format
  • Instr
  • LCase
  • Left
  • Mid
  • Right
  • UCase

Numeric functions

  • Standard operators
    • +, -, *, /
  • Abs
  • CDbl
  • CInt
  • Divide
  • Mod
  • Power

Financial functions

  • DDB
  • FV
  • IPmt
  • NPer
  • Pmt
  • PPmt
  • PV
  • Rate
  • SLN
  • SYD

Logical functions

  • IIf

Hierarchy functions

  • Levels
  • Members

Level functions

  • Members
  • Ordinal