Concepts
Setup
MDX Manual

MDX Introduction
Member Functions

Examples
SDK
ClosingPeriod
CurrentMember
FirstChild
FirstSibling
Lag
LastChild
LastSibling
Lead
OpeningPeriod
ParallelPeriod
Parent
PrevMember

Set Functions
BottomPercent
Children
CrossJoin
Descendants
Except
Filter
Intersect
LateralMembers
Members
Order
Tail
TopCount
TopPercent
Union
Ytd

Numeric Functions
Logical Functions
String Functions
Function | Description |

AddCalculatedMembers | Returns a set generated by adding calculated members to a specified set. |

AllMembers | Returns a set that contains all members, including calculated members, of the specified dimension, hierarchy, or level. |

Ancestors | Returns a set of all ancestors of a member at a specified level or distance. |

Ascendants | Returns the set of the ascendants of a specified member, including the member itself. |

Axis | Returns a set defined in an axis. |

BottomCount | Sorts a set in ascending order, and returns the specified number of tuples with the lowest values. |

BottomPercent | Sorts a set in ascending order, and returns a set of tuples with the lowest values whose cumulative total is equal to or less than a specified percentage. |

BottomSum | Sorts a set in ascending order, and returns a set of tuples with the lowest values whose total is equal to or less than a specified value. |

Children | Returns the children of a specified member. |

CrossJoin | Returns the cross product of one or more sets. |

CurrentOrdinal | Returns the current iteration number within a set during iteration. |

Descendants | Returns the set of descendants of a member at a specified level or distance, optionally including or excluding descendants in other levels. |

Distinct | Returns a set, removing duplicate tuples from a specified set. |

DrilldownLevel | Drills down the members of a set to one level below the lowest level represented in the set, or to one level below an optionally specified level of a member represented in the set. |

DrilldownLevelBottom | Drills down the bottommost members of a set, at a specified level, to one level below. |

DrilldownLevelTop | Drills down the topmost members of a set, at a specified level, to one level below. |

DrilldownMember | Drills down the members in a specified set that are present in a second specified set. Alternatively, the function drills down on a set of tuples. |

DrilldownMemberBottom | Drills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of members. Alternatively, this function also drills down on a set of tuples. |

DrilldownMemberTop | Drills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of members. Alternatively, this function drills down on a set of tuples. |

DrillupLevel | Drills up the members of a set that are below a specified level. |

DrillupMember | Drills up the members in a specified set that are present in a second specified set. |

Except | Finds the difference between two sets, optionally retaining duplicates. |

Exists | Returns the set of members of one set that exist with one or more tuples of one or more other sets. |

Extract | Returns a set of tuples from extracted dimension elements. |

Filter | Returns the set that results from filtering a specified set based on a search condition. |

Generate | Applies a set to each member of another set, and then joins the resulting sets by union. Alternatively, this function returns a concatenated string created by evaluating a string expression over a set. |

Head | Returns the first specified number of elements in a set, while retaining duplicates. |

Hierarchize | Orders the members of a set in a hierarchy. |

Intersect | Returns the intersection of two input sets, optionally retaining duplicates. |

LastPeriods | Returns a set of members up to and including a specified member. |

LateralMembers | |

Members | Returns the set of members in a dimension, level, or hierarchy. |

Mtd | Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Year level in the Time dimension. |

NameToSet | Returns a set that contains the member specified by an MDX-formatted string. |

NonEmptyCrossjoin | Returns the cross product of one or more sets as a set, excluding empty tuples and tuples without associated fact table data. |

Order | Arranges members of a specified set, optionally preserving or breaking the hierarchy. |

PeriodsToDate | Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by a specified level in the Time dimension. |

Qtd | Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Quarter level in the Time dimension. |

Siblings | Returns the siblings of a specified member, including the member itself. |

StripCalculatedMembers | Returns a set generated by removing calculated members from a specified set. |

StrToSet | Returns the set specified by an MDX-formatted string. |

Subset | Returns a subset of tuples from a specified set. |

Tail | Returns a subset from the end of a set. |

ToggleDrillState | Toggles the drill state of members. |

TopCount | Sorts a set in descending order and returns the specified number of elements with the highest values. |

TopPercent | Sorts a set in descending order, and returns a set of tuples with the highest values whose cumulative total is equal to or less than a specified percentage. |

TopSum | Sorts a set and returns the topmost elements whose cumulative total is at least a specified value. |

Union | Returns the union of two sets, optionally retaining duplicates. |

Unorder | Removes any enforced ordering from a specified set. |

VisualTotals | Returns a set generated by dynamically totaling child members in a specified set, optionally using a pattern for the name of the parent member in the resulting cellset. |

Wtd | Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Week level in the Time dimension. |

Ytd | Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Year level in the Time dimension. |

Community

Copyright © 2023 euclidolap.com. All Rights Reserved