📄️ Abs
Syntax
📄️ Aggregate
Returns a number that is calculated by aggregating over the cells returned by the set expression. If a numeric expression is not provided, this function aggregates each metric within the current query context by using the default aggregation operator specified for each metric. If a numeric expression is provided, this function first evaluates, and then aggregates, the numeric expression for each cell in the specified set. The numeric expression must contain an existing AtScale metric or calculated metric that has been defined in Design Center (ad-hoc metrics are not supported).
📄️ ALL
Refers to the "All" level with a single member called the "All" member. The "All" member is the default dimension member unless the referenced Hierarchy has an alternative default dimension member configured. Used to constrain a tuple expression. Usage of "All" is case sensitive in AtScale.
📄️ ALLMEMBER
Similar to the ALL() DAX function, this function evaluates a given tupleExpression as if all other model hierarchy references explicitly reference the hierarchy's ALL member.
📄️ ALLMEMBEREXCEPT
Similar to the ALLEXCEPT DAX function, this function evaluates a given tupleExpression as if all other model hierarchy references explicitly reference the hierarchy's ALL member, with the exception of the hierarchies listed in hierarchySet.
📄️ Ancestor
Syntax
📄️ Arithmetic Operators (MDX)
Arithmetic operators perform basic math operations on their operands.
📄️ Avg (MDX)
Returns the Average of a Measure evaluated over a specified set.
📄️ CASE
The CASE function evaluates each row in the dataset according to one or more input conditions, and outputs the specified result when the input conditions are met.
📄️ CBOOL
Casts the value to a Boolean. Returns False for String or Numeric expressions that evaluate to zero, else returns true.
📄️ CDBL
Casts the value to a Double. Returns Null if the cast is invalid
📄️ CDEC
Casts the value to a Decimal number. Returns Null if the cast is invalid.
📄️ Ceiling
Syntax
📄️ Children
Returns a naturally ordered set that contains the children of a specified member. For use with an aggregate function, i.e. SUM(Descendants(...), Measure). If the specified member has no children, this function returns an empty set.
📄️ CINT
Casts the value to an integer. Returns Null if the cast is invalid.
📄️ CLONG
Casts the value to a Long. Returns null if the cast is invalid.
📄️ Comparison Operators (MDX)
Comparison operators evaluate to a Boolean data type, returning true or
📄️ Count (Set)
Returns the non-distinct Count of non-empty dimension members referenced by the dimensional set expression.
📄️ Crossjoin
Returns a set that is the cross product of one or more sets. Used to combine members from multiple hierarchies into a set of tuples for the purpose of constraining the evaluation of a numeric expression before aggregation.
📄️ CSTR
Casts the value to a String. Returns Null if the cast is invalid.
📄️ CURRENTMEMBER.NAME
The CurrentMember.Name function returns the current member value of the specified dimension attribute during iteration.
📄️ DatesMTD
An alias for DatesPeriodsToDate with the LevelExpression argument dynamically set to the Month level of the MemberExpression argument's Time hierarchy.
📄️ DatesPeriodsToDate
Returns the set of dates corresponding to the range of Day members beginning on the first sibling member of LevelExpresson and ending on the member described by MemberExpression. The return set is constrained by filters applied to the Member_Expression argument's hierarchy in the query. As a result, Grand Totals and Subtotal Aggregations are limited to the filtered set.
📄️ DatesQTD
An alias for DatesPeriodsToDate with the LevelExpression argument dynamically set to the Quarter level of the MemberExpression argument's Time hierarchy.
📄️ DatesWTD
An alias for DatesPeriodsToDate with the LevelExpression argument dynamically set to the Week level of the MemberExpression argument's Time hierarchy.
📄️ DatesYTD
An alias for DatesPeriodsToDate with the LevelExpression argument dynamically set to the Year level of the MemberExpression argument's Time hierarchy.
📄️ Day
Syntax
📄️ Descendants
Returns the set of descendants of a member at a specified level or distance. For use with an aggregate function, i.e. SUM(Descendants(...), Measure). If the specified member has no Descendants, this function returns an empty set.
📄️ DIMENSION_UNIQUE_NAME
The unique name of the dimension to which this member belongs.
📄️ DIVIDE
Performs division and returns alternate result or BLANK() on division by zero.
📄️ E
Syntax
📄️ Except
Evaluates two sets and removes any tuples from the first set that also appear in the second. You can optionally specify to retain duplicates.
📄️ Exp
Syntax
📄️ ExtractMember
Returns a specific tuple from a set.
📄️ FirstChild
Syntax
📄️ FirstSibling
Syntax
📄️ Floor
Syntax
📄️ Head
Returns the specified number of tuples from the beginning of a set, in their original order.
📄️ HIERARCHY_UNIQUE_NAME
The unique name of the hierarchy.
📄️ Hour
Syntax
📄️ IIF
The IIF function evaluates one of two different expressions, depending on whether a Boolean condition is true or false.
📄️ INSTR
The InStr function returns the position of the first occurrence of one string within another string.
📄️ Intersect
Returns the intersection of two sets. By default, duplicates are removed from both sets before intersecting; however, you can optionally specify to retain duplicates.
📄️ ISEMPTY
The ISEMPTY function evaluates if a cell in a model is empty or not.
📄️ KEY
The value of the member key in the original data type. KEY has the same value as KEY0 for non-composite keys and KEY property is null for composite keys.
📄️ Lag
The Lag function returns a member that precedes the specified member by a specified number of positions in its level.
📄️ LastChild
Syntax
📄️ LastSibling
Syntax
📄️ Lead
The Lead function returns a member that follows the specified member by a specified number of positions in its level.
📄️ Left
Syntax
📄️ Len
Syntax
📄️ LEVEL_NUMBER
The distance of the member from the root of the hierarchy. The root level is ALL level and has a LEVEL_NUMBER of zero.
📄️ LEVEL_UNIQUE_NAME
The unique name of the level to which the member belongs.
📄️ Level
Syntax
📄️ Log
Syntax
📄️ Log10
Syntax
📄️ Log2
Syntax
📄️ Logical Operators (MDX)
Logical operators are used to combine arguments in a Boolean expression (an expression that evaluates to true or false).
📄️ Max (MDX)
Returns the Max of a Measure evaluated over a specified set.
📄️ MEMBER_CAPTION
A label or caption associated with the member. The caption is primarily for display purposes. If a caption does not exist, the query returns MEMBER_NAME.
📄️ MEMBER_KEY
The value of the member key in the original datatype. MEMBERKEY is for backward-compatibility. MEMBERKEY has the same value as KEY0 for non-composite keys, and MEMBER_KEY property is null for composite keys.
📄️ MEMBER_LEVEL_NUMBER
The distance of the member from the root of the hierarchy. The root level is the ALL level and has a LEVEL_NUMBER of zero.
📄️ MEMBER_NAME
The name of the member.
📄️ Members
Returns the set of members in a dimension, level, or hierarchy.
📄️ Mid
Syntax
📄️ Min (MDX)
Returns the min of a Measure evaluated over a specified set.
📄️ Minute
Syntax
📄️ Month
Syntax
📄️ NextMember
The NextMember function returns the member that follows the specified member in the level.
📄️ NonEmpty
Returns the non-empty tuples from a set, based on the cross product of the set with a measure.
📄️ Now
Syntax
📄️ NULLEXCEPT
Evaluates the given tuple expression when the query includes any of the hierarchies listed in the hierarchySet argument, else returns NULL. Totals that hierarchySet contributes to are displayed, else a NULL value is displayed for the total (this applies to both subtotals and grand totals).
📄️ ParallelPeriod
Returns the member whose ancestor at the specified level is a specified number of positions from the specified member's ancestor of the same level. ParallelPeriod is typically used to navigate a time-based hierarchy. For example, if you specify the year level with an index of one for the specified member June 2019, a lag of one at the year level from 2019 is 2018. The function returns the member June 2018.
📄️ PARENT_COUNT
The number of parents that this member has.
📄️ PARENT_LEVEL
The distance of the member's parent from the root level of the hierarchy. The root level is zero.
📄️ Parent
Syntax
📄️ PeriodsToDate
Returns a set of sibling members from the specified level of a time dimension, beginning with the first sibling and ending with a specified member.
📄️ Pi
Syntax
📄️ POW
Syntax
📄️ PrevMember
The PrevMember function returns the member that precedes the specified member in the level.
📄️ Properties
Returns the value of the specified member for the specified member property. Can be used for both system- and user-defined member properties.
📄️ Rand
Syntax
📄️ Right
Syntax
📄️ Round
Syntax
📄️ Second
Syntax
📄️ Set Operators (MDX)
Set operators perform operations on members or sets and returns a set. AtScale supports set operators in Calculated Measure formulas.
📄️ Siblings
Returns a naturally ordered set that contains the siblings of a specified member, including the member itself. For use with an aggregate function, i.e. SUM( MemberExpression, Measure).
📄️ Sign
Syntax
📄️ SQLSUM
The SQLSUM function returns the sum of its arguments.
📄️ Sum (MDX)
Returns the sum of a Measure evaluated over a specified set.
📄️ Tail
Returns the specified number of tuples from the end of a set, in their original order.
📄️ Trigonometric Functions
AtScale supports the following MDX trigonometric functions in a calculated measure formula.
📄️ TRIM | LTRIM | RTRIM
The TRIM function removes both leading and trailing spaces from the specified string. LTRIM removes just leading spaces, and RTRIM removes just trailing spaces.
📄️ Truncate
Syntax
📄️ Tuple Expressions
AtScale supports simple model-sided tuple expressions for calculated measures.
📄️ UCASE | LCASE
The UCASE converts all alphabetic characters in a string to all upper case. LCASE converts all alphabetic characters in a string to all lower case.
📄️ Union
Returns a set that is generated by the union of two sets. By default, duplicates are deleted from the tail end of the set; however, you can optionally specify to retain duplicates.
🗃️ VBA Date Functions
25 items
📄️ XIRR
Calculates the rate of return (within .000001%) of investments that have irregular payment schedules.
📄️ Year
Syntax