XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |

# XLCubed MDX Calculation Support

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

### Set functions

`{ }`

- braces- Multiple members/tuples can be combined
- Range operator
`:`

is supported

- Ancestors
- Children
- Head
- Items
- LastPeriods
- PeriodsToDate
- Siblings
- Subset
- Tail

### Member functions

- Ancestor
- ClosingPeriod
- Cousin
- CurrentMember
- DefaultMember
- Descendants
- FirstMember
- FirstSibling
- Items
- 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

- Abs
- CDbl
- CInt
- Divide
- Mod
- Power

### Logical functions

- IIf

### Hierarchy functions

- Members

### Level functions

- Members
- Ordinal