| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XLCubed MDX Calculation Support"
(→Supported Functions) |
|||
| Line 4: | Line 4: | ||
==Supported Functions== | ==Supported Functions== | ||
| + | |||
| + | Documentation for these functions can be found in the [https://docs.microsoft.com/en-us/sql/mdx/mdx-function-reference-mdx MDX function reference]. | ||
===Set functions=== | ===Set functions=== | ||
| Line 94: | Line 96: | ||
* Members | * Members | ||
* Ordinal | * Ordinal | ||
| − | |||
==Sample Calculations== | ==Sample Calculations== | ||
Revision as of 10:32, 25 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.
Contents
Supported Functions
Documentation for these functions can be found in the MDX function reference.
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
- Len
- LTrim
- Mid
- Right
- RTrim
- Trim
- 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
Sample Calculations
These templates may be useful starting poitns for your own calculations. You should replace the Dimension, Hierarchy, Level and Measure names with your own.
