| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XLCubed MDX Calculation Support"
| Line 39: | Line 39: | ||
* Parent | * Parent | ||
* PrevMember | * PrevMember | ||
| − | |||
===Aggregation funtions=== | ===Aggregation funtions=== | ||
| Line 60: | Line 59: | ||
===Numeric functions=== | ===Numeric functions=== | ||
| + | * Standard operators | ||
| + | ** +, -, *, / | ||
* Abs | * Abs | ||
* CDbl | * CDbl | ||
Revision as of 10:27, 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.
Contents
[hide]Supported Functions
Set functions
{ }- braces- Multiple members/tuples can be combined
- Range operator
:is supported
- 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
Logical functions
- IIf
Hierarchy functions
- Levels
- Members
Level functions
- Members
- Ordinal
