PATHLENGTH
Returns the number of parents to the specified item in a given PATH result, including self.
Archive
PATHITEMREVERSE
Returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted backwards from right to left.
PATHITEM
Returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted from left to right.
PATHCONTAINS
Returns TRUE if the specified item exists within the specified path.
PATH
Returns a delimited text string with the identifiers of all the parents of the current identifier, starting with the oldest and continuing until current.
UNION
Creates a union (join) table from a pair of tables.
TREATAS
Applies the result of a table expression as filters to columns from an unrelated table.
Table Constructor
Returns a table of one or more columns.
SUMMARIZECOLUMNS
Returns a summary table over a set of groups.
SELECTEDMEASURENAME
Used by expressions for calculation items to determine the measure that is in context by name.