| Server IP : 180.180.241.3 / Your IP : 216.73.216.35 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/Microsoft SQL Server/110/Tools/Templates/olap/1033/ |
Upload File : |
<?xml version="1.0" encoding="utf-8"?>
<MDXFunctions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/AnalysisServices/MDXFunctions">
<_locDefinition>
<_locDefault _loc="locNone" />
<_locTag _loc="locData">Category</_locTag>
<_locTag _loc="locData">Description</_locTag>
</_locDefinition>
<Function>
<Name>ADDCALCULATEDMEMBERS</Name>
<Category>Set</Category>
<Description>Returns a set generated by adding calculated members to a specified set.</Description>
<Template>ADDCALCULATEDMEMBERS( «Set» )</Template>
</Function>
<Function>
<Name>AGGREGATE</Name>
<Category>Statistical</Category>
<Description>Returns a calculated value using the appropriate aggregate function, based on the aggregation type of the member.</Description>
<Template>AGGREGATE( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>ALLMEMBERS</Name>
<Category>Set</Category>
<Description>Returns a set containing all members of the level, including calculated members.</Description>
<Template>«Level».ALLMEMBERS</Template>
</Function>
<Function>
<Name>ALLMEMBERS</Name>
<Category>Set</Category>
<Description>Returns a set containing all members of the hierarchy, including calculated members.</Description>
<Template>«Hierarchy».ALLMEMBERS</Template>
</Function>
<Function>
<Name>ANCESTOR</Name>
<Category>Navigation</Category>
<Description>Returns the ancestor of a member at a specified level.</Description>
<Template>ANCESTOR( «Member», «Level» )</Template>
</Function>
<Function>
<Name>ANCESTOR</Name>
<Category>Navigation</Category>
<Description>Returns the ancestor of a member at a specific distance away in the hierarchy.</Description>
<Template>ANCESTOR( «Member», «Distance» )</Template>
</Function>
<Function>
<Name>ANCESTORS</Name>
<Category>Navigation</Category>
<Description>Returns a set of all ancestors of a member at a specific distance above the member in the hierarchy.</Description>
<Template>ANCESTORS( «Member», «Distance» )</Template>
</Function>
<Function>
<Name>ANCESTORS</Name>
<Category>Navigation</Category>
<Description>Returns a set of all ancestors of a member at a specified level.</Description>
<Template>ANCESTORS( «Member», «Level» )</Template>
</Function>
<Function>
<Name>ASCENDANTS</Name>
<Category>Navigation</Category>
<Description>Returns the set of the ascendants of the member.</Description>
<Template>ASCENDANTS( «Member» )</Template>
</Function>
<Function>
<Name>AVG</Name>
<Category>Statistical</Category>
<Description>Returns the average value of a numeric expression evaluated over a set.</Description>
<Template>AVG( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>AXIS</Name>
<Category>Metadata</Category>
<Description>Returns a set defined in an axis.</Description>
<Template>AXIS( «Numeric Expression» )</Template>
</Function>
<Function>
<Name>BOTTOMNCOUNT</Name>
<Category>Set</Category>
<Description>Returns a specified number of items from the bottom of a set, optionally sorting the set first.</Description>
<Template>BOTTOMNCOUNT( «Set», «Count»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>BOTTOMPERCENT</Name>
<Category>Set</Category>
<Description>Sorts a set and returns the specified number of bottommost elements whose cumulative total is at least a specified percentage.</Description>
<Template>BOTTOMPERCENT( «Set», «Percentage», «Numeric Expression» )</Template>
</Function>
<Function>
<Name>BOTTOMSUM</Name>
<Category>Set</Category>
<Description>Sorts a set and returns the specified number of bottommost elements whose cumulative total is at least a specified value.</Description>
<Template>BOTTOMSUM( «Set», «Value», «Numeric Expression» )</Template>
</Function>
<Function>
<Name>CALCULATIONCURRENTPASS</Name>
<Category>Other</Category>
<Description>Returns the current calculation pass of a cube for the specified query context.</Description>
<Template>CALCULATIONCURRENTPASS</Template>
</Function>
<Function>
<Name>CALCULATIONPASSVALUE</Name>
<Category>Other</Category>
<Description>Returns the value of a numeric MDX expression evaluated over the specified calculation pass of a cube.</Description>
<Template>CALCULATIONPASSVALUE( «Numeric Expression», «Pass Value»[[, «Access Flag»], ALL] )</Template>
</Function>
<Function>
<Name>CHILDREN</Name>
<Category>Navigation</Category>
<Description>Returns the children of a member.</Description>
<Template>«Member».CHILDREN</Template>
</Function>
<Function>
<Name>CLOSINGPERIOD</Name>
<Category>Time</Category>
<Description>Returns the last sibling among the descendants of a member at a specified level.</Description>
<Template>CLOSINGPERIOD( [«Level»[, «Member»] ] )</Template>
</Function>
<Function>
<Name>COALESCEEMPTY</Name>
<Category>Statistical</Category>
<Description>Coalesces an empty cell value to a number.</Description>
<Template>COALESCEEMPTY( «Numeric Expression»[, «Numeric Expression»...] )</Template>
</Function>
<Function>
<Name>CORRELATION</Name>
<Category>Statistical</Category>
<Description>Returns the correlation of two series evaluated over a set.</Description>
<Template>CORRELATION( «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>DIMENSIONS.COUNT</Name>
<Category>Metadata</Category>
<Description>Counts the number of hierarchies in the cube.</Description>
<Template>DIMENSIONS.COUNT</Template>
</Function>
<Function>
<Name>COUNT</Name>
<Category>Metadata</Category>
<Description>Counts the number of members in the tuple.</Description>
<Template>«Tuple».COUNT</Template>
</Function>
<Function>
<Name>COUNT</Name>
<Category>Statistical</Category>
<Description>Counts the number of tuples in the set.</Description>
<Template>«Set».COUNT</Template>
</Function>
<Function>
<Name>LEVELS.COUNT</Name>
<Category>Metadata</Category>
<Description>Counts the number of levels in the hierarchy.</Description>
<Template>«Hierarchy».LEVELS.COUNT</Template>
</Function>
<Function>
<Name>COUNT</Name>
<Category>Statistical</Category>
<Description>Returns the number of tuples in a set, optionally including or excluding empty tuples.</Description>
<Template>COUNT( «Set»[, EXCLUDEEMPTY | INCLUDEEMPTY] )</Template>
</Function>
<Function>
<Name>COUSIN</Name>
<Category>Navigation</Category>
<Description>Returns the child member with the same relative position under a parent member as the specified child member.</Description>
<Template>COUSIN( «Member1», «Member2» )</Template>
</Function>
<Function>
<Name>COVARIANCE</Name>
<Category>Statistical</Category>
<Description>Returns the covariance of two series evaluated over a set, using the biased population formula.</Description>
<Template>COVARIANCE( «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>COVARIANCEN</Name>
<Category>Statistical</Category>
<Description>Returns the covariance of two series evaluated over a set, using the unbiased population formula.</Description>
<Template>COVARIANCEN( «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>CROSSJOIN</Name>
<Category>Set</Category>
<Description>Returns the cross product of two sets.</Description>
<Template>CROSSJOIN( «Set1», «Set2» )</Template>
</Function>
<Function>
<Name>CURRENT</Name>
<Category>Navigation</Category>
<Description>Returns the current tuple from a set during an iteration.</Description>
<Template>«Set».CURRENT</Template>
</Function>
<Function>
<Name>CURRENTMEMBER</Name>
<Category>Navigation</Category>
<Description>Returns the current member along a hierarchy</Description>
<Template>«Hierarchy».CURRENTMEMBER</Template>
</Function>
<Function>
<Name>CURRENTORDINAL</Name>
<Category>Navigation</Category>
<Description>Returns the current ordinal during an iteration over a set</Description>
<Template>«Set».CURRENTORDINAL</Template>
</Function>
<Function>
<Name>CUSTOMDATA</Name>
<Category>Other</Category>
<Description>Returns the value of CustomData property</Description>
<Template>CUSTOMDATA</Template>
</Function>
<Function>
<Name>DATAMEMBER</Name>
<Category>Navigation</Category>
<Description>Returns the system-generated data member associated with a nonleaf member.</Description>
<Template>«Member».DATAMEMBER</Template>
</Function>
<Function>
<Name>DEFAULTMEMBER</Name>
<Category>Navigation</Category>
<Description>Returns the default member of a hierarchy.</Description>
<Template>«Hierarchy».DEFAULTMEMBER</Template>
</Function>
<Function>
<Name>DESCENDANTS</Name>
<Category>Set</Category>
<Description>Returns the set of descendants of a member at a specified level, optionally including or excluding descendants in other levels.</Description>
<Template>DESCENDANTS( «Member»[, «Level»[, «Desc_flags»]] )</Template>
</Function>
<Function>
<Name>DESCENDANTS</Name>
<Category>Set</Category>
<Description>Returns the set of descendants of a member at a specific distance away in the hierarchy, optionally including or excluding descendants in other levels.</Description>
<Template>DESCENDANTS( «Member»,«Distance»[, «Desc_flags»] )</Template>
</Function>
<Function>
<Name>DISTINCT</Name>
<Category>Set</Category>
<Description>Returns a set, removing duplicate tuples from a specified set.</Description>
<Template>DISTINCT( «Set» )</Template>
</Function>
<Function>
<Name>DISTINCTCOUNT</Name>
<Category>Statistical</Category>
<Description>Returns the number of distinct tuples in a set.</Description>
<Template>DISTINCTCOUNT( «Set» )</Template>
</Function>
<Function>
<Name>DRILLDOWNLEVEL</Name>
<Category>UI</Category>
<Description>Drills down the members of a set one level below the lowest level represented in the set, or to one level below an optional level of a member represented in the set.</Description>
<Template>DRILLDOWNLEVEL( «Set»[, «Level» ] )</Template>
</Function>
<Function>
<Name>DRILLDOWNLEVEL</Name>
<Category>UI</Category>
<Description>Drills down the members of a set one level below the lowest level represented in the set, or to one level below a dimension optionally selected by its zero-based index of a member represented in the set.</Description>
<Template>DRILLDOWNLEVEL( «Set»[, , «Index»] )</Template>
</Function>
<Function>
<Name>DRILLDOWNLEVELBOTTOM</Name>
<Category>UI</Category>
<Description>Drills down the members of a specified count of bottom members of a set, at a specified level, to one level below.</Description>
<Template>DRILLDOWNLEVELBOTTOM( «Set», «Count»[, [«Level»][, «Numeric Expression»] ] )</Template>
</Function>
<Function>
<Name>DRILLDOWNLEVELTOP</Name>
<Category>UI</Category>
<Description>Drills down a specified count of top members of a set, at a specified level, to one level below.</Description>
<Template>DRILLDOWNLEVELTOP( «Set», «Count»[, [«Level»][, «Numeric Expression»] ] )</Template>
</Function>
<Function>
<Name>DRILLDOWNMEMBER</Name>
<Category>UI</Category>
<Description>Drills down the members in a specified set that are present in a second specified set.</Description>
<Template>DRILLDOWNMEMBER( «Set1», «Set2»[, RECURSIVE] )</Template>
</Function>
<Function>
<Name>DRILLDOWNMEMBERBOTTOM</Name>
<Category>UI</Category>
<Description>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 bottommost members.</Description>
<Template>DRILLDOWNMEMBERBOTTOM( «Set1», «Set2», «Count»[, [«Numeric Expression»] [, RECURSIVE] ] )</Template>
</Function>
<Function>
<Name>DRILLDOWNMEMBERTOP</Name>
<Category>UI</Category>
<Description>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 topmost members.</Description>
<Template>DRILLDOWNMEMBERTOP( «Set1», «Set2», «Count»[, [«Numeric Expression»] [, RECURSIVE] ] )</Template>
</Function>
<Function>
<Name>DRILLUPLEVEL</Name>
<Category>UI</Category>
<Description>Drills up the members of a set that are below a specified level.</Description>
<Template>DRILLUPLEVEL( «Set»[, «Level»] )</Template>
</Function>
<Function>
<Name>DRILLUPMEMBER</Name>
<Category>UI</Category>
<Description>Drills up the members in a specified set that are present in a second specified set.</Description>
<Template>DRILLUPMEMBER( «Set1», «Set2» )</Template>
</Function>
<Function>
<Name>EXCEPT</Name>
<Category>Set</Category>
<Description>Finds the difference between two sets, optionally retaining duplicates.</Description>
<Template>EXCEPT( «Set1», «Set2»[, ALL] )</Template>
</Function>
<Function>
<Name>EXISTING</Name>
<Category>Set</Category>
<Description />
<Template>EXISTING</Template>
</Function>
<Function>
<Name>EXISTS</Name>
<Category>Set</Category>
<Description />
<Template>EXISTS( «Set1», «Set2» )</Template>
</Function>
<Function>
<Name>EXTRACT</Name>
<Category>Set</Category>
<Description>Returns a set of tuples from extracted dimension elements.</Description>
<Template>EXTRACT( «Set», «Dimension»[, «Dimension»...] )</Template>
</Function>
<Function>
<Name>FILTER</Name>
<Category>Set</Category>
<Description>Returns the set resulting from filtering a set based on a search condition.</Description>
<Template>FILTER( «Set», «Search Condition» )</Template>
</Function>
<Function>
<Name>FIRSTCHILD</Name>
<Category>Navigation</Category>
<Description>Returns the first child of a specified member.</Description>
<Template>«Member».FIRSTCHILD</Template>
</Function>
<Function>
<Name>FIRSTSIBLING</Name>
<Category>Navigation</Category>
<Description>Returns the first child of the parent of a specified member.</Description>
<Template>«Member».FIRSTSIBLING</Template>
</Function>
<Function>
<Name>GENERATE</Name>
<Category>Set</Category>
<Description>Applies a set to each member of another set and joins the resulting sets by union.</Description>
<Template>GENERATE( «Set1», «Set2»[, ALL] )</Template>
</Function>
<Function>
<Name>GENERATE</Name>
<Category>String</Category>
<Description>Returns a concatenated string created by evaluating a string expression over a set.</Description>
<Template>GENERATE( «Set», «String Expression»[, «Delimiter»] )</Template>
</Function>
<Function>
<Name>HEAD</Name>
<Category>Set</Category>
<Description>Returns the first specified number of elements in a set.</Description>
<Template>HEAD( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>HIERARCHIZE</Name>
<Category>Set</Category>
<Description>Orders the members of a specified set in a hierarchy in natural or, optionally, post-natural order.</Description>
<Template>HIERARCHIZE( «Set»[, POST] )</Template>
</Function>
<Function>
<Name>HIERARCHY</Name>
<Category>Metadata</Category>
<Description>Returns the hierarchy of a specified level.</Description>
<Template>«Level».HIERARCHY</Template>
</Function>
<Function>
<Name>HIERARCHY</Name>
<Category>Metadata</Category>
<Description>Returns the hierarchy of a specified dimension.</Description>
<Template>«Member».HIERARCHY</Template>
</Function>
<Function>
<Name>IIF</Name>
<Category>Value</Category>
<Description>Returns one of values determined by a logical test.</Description>
<Template>IIF( «Logical Expression», «object», «object» )</Template>
</Function>
<Function>
<Name>INTERSECT</Name>
<Category>Set</Category>
<Description>Returns the intersection of two sets, optionally retaining duplicates.</Description>
<Template>INTERSECT( «Set1», «Set2»[, ALL] )</Template>
</Function>
<Function>
<Name>IS</Name>
<Category>Value</Category>
<Description>Returns TRUE if two compared objects are equivalent, FALSE otherwise.</Description>
<Template>IS</Template>
</Function>
<Function>
<Name>ISANCESTOR</Name>
<Category>Navigation</Category>
<Description>Returns TRUE if a specified member is an ancestor of another specified member, FALSE otherwise.</Description>
<Template>ISANCESTOR( «Member1»,«Member2» )</Template>
</Function>
<Function>
<Name>ISEMPTY</Name>
<Category>Value</Category>
<Description>Returns TRUE if the evaluated expression is the empty cell value, FALSE otherwise.</Description>
<Template>ISEMPTY( «Value Expression» )</Template>
</Function>
<Function>
<Name>ISGENERATION</Name>
<Category>Navigation</Category>
<Description>Returns TRUE if a specified member is in a specified generation, FALSE otherwise.</Description>
<Template>ISGENERATION( «Member»,«Numeric Expression» )</Template>
</Function>
<Function>
<Name>ISLEAF</Name>
<Category>Navigation</Category>
<Description>Returns TRUE if a specified member is a leaf member, FALSE otherwise.</Description>
<Template>ISLEAF( «Member» )</Template>
</Function>
<Function>
<Name>ISSIBLING</Name>
<Category>Navigation</Category>
<Description>Returns TRUE if a specified member is a sibling of another specified member, FALSE otherwise.</Description>
<Template>ISSIBLING( «Member1»,«Member2» )</Template>
</Function>
<Function>
<Name>ITEM</Name>
<Category>Other</Category>
<Description>Returns a member from a specified tuple.</Description>
<Template>«Tuple».ITEM( «Numeric Expression» )</Template>
</Function>
<Function>
<Name>ITEM</Name>
<Category>Other</Category>
<Description>Returns a tuple from a specified set.</Description>
<Template>«Set».ITEM( «String Expression»[, «String Expression»...] | «Index» )</Template>
</Function>
<Function>
<Name>KPICURRENTTIMEMEMBER</Name>
<Category>KPI</Category>
<Description>Returns the current time member of the KPI</Description>
<Template>KPICURRENTTIMEMEMBER( «String Expression» )</Template>
</Function>
<Function>
<Name>KPIGOAL</Name>
<Category>KPI</Category>
<Description>Returns the goal of the KPI.</Description>
<Template>KPIGOAL( «String Expression» )</Template>
</Function>
<Function>
<Name>KPISTATUS</Name>
<Category>KPI</Category>
<Description>Returns the measure with normalized status between -1 and 1 of the KPI. </Description>
<Template>KPISTATUS( «String Expression» )</Template>
</Function>
<Function>
<Name>KPITREND</Name>
<Category>KPI</Category>
<Description>Returns the measure with normalized trend between -1 and 1 of the KPI</Description>
<Template>KPITREND( «String Expression» )</Template>
</Function>
<Function>
<Name>KPIVALUE</Name>
<Category>KPI</Category>
<Description>Returns the measure with normalized value between -1 and 1 of the KPI</Description>
<Template>KPIVALUE( «String Expression» )</Template>
</Function>
<Function>
<Name>KPIWEIGHT</Name>
<Category>KPI</Category>
<Description>Returns the measure with weight of the KPI</Description>
<Template>KPIWEIGHT( «String Expression» )</Template>
</Function>
<Function>
<Name>LAG</Name>
<Category>Navigation</Category>
<Description>Returns the member that is a specified number of positions prior to a specified member along the dimension of the member.</Description>
<Template>«Member».LAG( «Numeric Expression» )</Template>
</Function>
<Function>
<Name>LASTCHILD</Name>
<Category>Navigation</Category>
<Description>Returns the last child of a specified member.</Description>
<Template>«Member».LASTCHILD</Template>
</Function>
<Function>
<Name>LASTPERIODS</Name>
<Category>Time</Category>
<Description>Returns a set of members prior to and including a specified member.</Description>
<Template>LASTPERIODS( «Index»[, «Member»] )</Template>
</Function>
<Function>
<Name>LASTSIBLING</Name>
<Category>Navigation</Category>
<Description>Returns the last child of the parent of a specified member.</Description>
<Template>«Member».LASTSIBLING</Template>
</Function>
<Function>
<Name>LEAD</Name>
<Category>Navigation</Category>
<Description>Returns the member that is a specified number of positions following a specified member along the dimension of the member.</Description>
<Template>«Member».LEAD( «Numeric Expression» )</Template>
</Function>
<Function>
<Name>LEVEL</Name>
<Category>Metadata</Category>
<Description>Returns the level of a member.</Description>
<Template>«Member».LEVEL</Template>
</Function>
<Function>
<Name>LEVELS</Name>
<Category>Metadata</Category>
<Description>Returns the level whose zero-based position in a dimension is specified by a numeric expression.</Description>
<Template>«Hierarchy».LEVELS( «Numeric Expression» )</Template>
</Function>
<Function>
<Name>LINKMEMBER</Name>
<Category>Navigation</Category>
<Description>Returns the member equivalent to a specified member in a specified hierarchy.</Description>
<Template>LINKMEMBER( «Member>, «Hierarchy» )</Template>
</Function>
<Function>
<Name>LINREGINTERCEPT</Name>
<Category>Statistical</Category>
<Description>Calculates the linear regression of a set and returns the value of b in the regression line y = ax + b.</Description>
<Template>LINREGINTERCEPT( «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>LINREGPOINT</Name>
<Category>Statistical</Category>
<Description>Calculates the linear regression of a set and returns the value of y in the regression line y = ax + b.</Description>
<Template>LINREGPOINT( «Numeric Expression», «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>LINREGR2</Name>
<Category>Statistical</Category>
<Description>Calculates the linear regression of a set and returns R² (the coefficient of determination).</Description>
<Template>LINREGR2( «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>LINREGSLOPE</Name>
<Category>Statistical</Category>
<Description>Calculates the linear regression of a set and returns the value of a in the regression line y = ax + b.</Description>
<Template>LINREGSLOPE( «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>LINREGVARIANCE</Name>
<Category>Statistical</Category>
<Description>Calculates the linear regression of a set and returns the variance associated with the regression line y = ax + b.</Description>
<Template>LINREGVARIANCE( «Set», «Numeric Expression»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>LOOKUPCUBE</Name>
<Category>Navigation</Category>
<Description>Returns the value of an MDX expression evaluated over another specified cube in the same database.</Description>
<Template>LOOKUPCUBE( «Cube Name», «Numeric Expression» )</Template>
</Function>
<Function>
<Name>MAX</Name>
<Category>Statistical</Category>
<Description>Returns the maximum value of a numeric expression evaluated over a set.</Description>
<Template>MAX( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>MEASUREGROUPMEASURES</Name>
<Category>Set</Category>
<Description>Returns the set of measures in the measure group.</Description>
<Template>MEASUREGROUPMEASURES( «String Expression» )</Template>
</Function>
<Function>
<Name>MEDIAN</Name>
<Category>Statistical</Category>
<Description>Returns the median value of a numeric expression evaluated over a set.</Description>
<Template>MEDIAN( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>MEMBERS</Name>
<Category>Set</Category>
<Description>Returns the set of all members in a specified hierarchy.</Description>
<Template>«Hierarchy».MEMBERS</Template>
</Function>
<Function>
<Name>MEMBERS</Name>
<Category>Set</Category>
<Description>Returns the set of all members at a specified level in a dimension.</Description>
<Template>«Level».MEMBERS</Template>
</Function>
<Function>
<Name>MEMBERTOSTR</Name>
<Category>String</Category>
<Description>Returns a string in Multidimensional Expressions (MDX) format from a member.</Description>
<Template>MEMBERTOSTR( «Member» )</Template>
</Function>
<Function>
<Name>MEMBERVALUE</Name>
<Category>Value</Category>
<Description>Returns the value of a member with its original data type.</Description>
<Template>«Member».MEMBERVALUE</Template>
</Function>
<Function>
<Name>MIN</Name>
<Category>Statistical</Category>
<Description>Returns the minimum value of a numeric expression evaluated over a set.</Description>
<Template>MIN( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>MTD</Name>
<Category>Time</Category>
<Description>Returns a set of members from the Month level in a Time dimension starting with the first period and ending with a specified member.</Description>
<Template>MTD( [«Member»] )</Template>
</Function>
<Function>
<Name>NAME</Name>
<Category>Metadata</Category>
<Description>Returns the name of a specified member.</Description>
<Template>«Member».NAME</Template>
</Function>
<Function>
<Name>NAME</Name>
<Category>Metadata</Category>
<Description>Returns the name of a specified hierarchy.</Description>
<Template>«Hierarchy».NAME</Template>
</Function>
<Function>
<Name>NAME</Name>
<Category>Metadata</Category>
<Description>Returns the name of a specified level.</Description>
<Template>«Level».NAME( Level )</Template>
</Function>
<Function>
<Name>NAMETOSET</Name>
<Category>String</Category>
<Description>Returns a set containing a single member based on a string expression containing a member name.</Description>
<Template>NAMETOSET( «Member Name» )</Template>
</Function>
<Function>
<Name>NEXTMEMBER</Name>
<Category>Navigation</Category>
<Description>Returns the next member in the level that contains a specified member.</Description>
<Template>«Member».NEXTMEMBER</Template>
</Function>
<Function>
<Name>NONEMPTY</Name>
<Category>Set</Category>
<Description>Returns subset of first set with removed empty tuples based on the cross product with a second set.</Description>
<Template>NONEMPTY( «Set1», «Set2» )</Template>
</Function>
<Function>
<Name>NONEMPTYCROSSJOIN</Name>
<Category>Set</Category>
<Description>Returns the cross product of two or more sets as a set, excluding empty members.</Description>
<Template>NONEMPTYCROSSJOIN( «Set1», «Set2»[, «Set3»...][, «Crossjoin Count»] )</Template>
</Function>
<Function>
<Name>OPENINGPERIOD</Name>
<Category>Time</Category>
<Description>Returns the first sibling among the descendants of a specified level, optionally at a specified member.</Description>
<Template>OPENINGPERIOD( [«Level»[, «Member»] ] )</Template>
</Function>
<Function>
<Name>ORDER</Name>
<Category>Set</Category>
<Description>Arranges the members of a specified set, optionally preserving or breaking the hierarchy.</Description>
<Template>ORDER( «Set», {«String Expression» | «Numeric Expression»}[, ASC | DESC | BASC | BDESC] )</Template>
</Function>
<Function>
<Name>ORDINAL</Name>
<Category>Metadata</Category>
<Description>Returns the zero-based ordinal value associated with a specified level.</Description>
<Template>«Level».ORDINAL</Template>
</Function>
<Function>
<Name>PARALLELPERIOD</Name>
<Category>Time</Category>
<Description>Returns a member from a prior period in the same relative position as a specified member.</Description>
<Template>PARALLELPERIOD( [«Level»[, «Numeric Expression»[, «Member»] ] ] )</Template>
</Function>
<Function>
<Name>PARENT</Name>
<Category>Navigation</Category>
<Description>Returns the parent of a specified member.</Description>
<Template>«Member».PARENT</Template>
</Function>
<Function>
<Name>PERIODSTODATE</Name>
<Category>Time</Category>
<Description>Returns a set of members (periods) from a specified level starting with the first member and ending with a specified member.</Description>
<Template>PERIODSTODATE( [«Level»[, «Member»] ] )</Template>
</Function>
<Function>
<Name>PREDICT</Name>
<Category>Other</Category>
<Description>Returns a value of a numeric expression evaluated over a data mining model.</Description>
<Template>PREDICT( «Mining Model Name», «Numeric Expression» )</Template>
</Function>
<Function>
<Name>PREVMEMBER</Name>
<Category>Navigation</Category>
<Description>Returns the previous member in the level that contains a specified member.</Description>
<Template>«Member».PREVMEMBER</Template>
</Function>
<Function>
<Name>PROPERTIES</Name>
<Category>Navigation</Category>
<Description>Returns a string containing the value of the specified member property.</Description>
<Template>«Member».PROPERTIES( «String Expression»[, TYPED] )</Template>
</Function>
<Function>
<Name>QTD</Name>
<Category>Time</Category>
<Description>Returns a set of members from the Quarter level in a Time dimension starting with the first period and ending with a specified member.</Description>
<Template>QTD( [«Member»] )</Template>
</Function>
<Function>
<Name>RANK</Name>
<Category>Statistical</Category>
<Description>Returns the one-based rank of a specified tuple in a specified set.</Description>
<Template>RANK( «Tuple», «Set» )</Template>
</Function>
<Function>
<Name>ROLLUPCHILDREN</Name>
<Category>Statistical</Category>
<Description>Returns a value generated by rolling up the values of the children of a specified member using the specified unary operator.</Description>
<Template>ROLLUPCHILDREN( «Member», «String Expression» )</Template>
</Function>
<Function>
<Name>SETTOARRAY</Name>
<Category>Other</Category>
<Description>Converts one or more sets to an array for use in a user-defined function.</Description>
<Template>SETTOARRAY( «Set»[, «Set»...][, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>SETTOSTR</Name>
<Category>String</Category>
<Description>Constructs a string in MDX format from a set.</Description>
<Template>SETTOSTR( «Set» )</Template>
</Function>
<Function>
<Name>SIBLINGS</Name>
<Category>Navigation</Category>
<Description>Returns the set of siblings of a specified member, including the member itself.</Description>
<Template>«Member».SIBLINGS</Template>
</Function>
<Function>
<Name>STDDEV</Name>
<Category>Statistical</Category>
<Description>Returns the standard deviation of a numeric expression evaluated over a set, using an unbiased population. (Alias for Stdev.)</Description>
<Template>STDDEV( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>STDDEVP</Name>
<Category>Statistical</Category>
<Description>Returns the standard deviation of a numeric expression evaluated over a set, using a biased population. (Alias for StdevP.)</Description>
<Template>STDDEVP( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>STDEVP</Name>
<Category>Statistical</Category>
<Description>Returns the standard deviation of a numeric expression evaluated over a set, using an unbiased population.</Description>
<Template>STDEVP( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>STDEVP</Name>
<Category>Statistical</Category>
<Description>Returns the standard deviation of a numeric expression evaluated over a set, using a biased population.</Description>
<Template>STDEVP( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>STRIPCALCULATEDMEMBERS</Name>
<Category>Set</Category>
<Description>Returns a set generated by removing calculated members from a specified set.</Description>
<Template>STRIPCALCULATEDMEMBERS( «Set» )</Template>
</Function>
<Function>
<Name>STRTOMEMBER</Name>
<Category>String</Category>
<Description>Returns a member from a string expression in MDX format.</Description>
<Template>STRTOMEMBER( «String Expression» )</Template>
</Function>
<Function>
<Name>STRTOSET</Name>
<Category>String</Category>
<Description>Constructs a set from a specified string expression in MDX format.</Description>
<Template>STRTOSET( «String Expression» )</Template>
</Function>
<Function>
<Name>STRTOTUPLE</Name>
<Category>String</Category>
<Description>Constructs a tuple from a specified string expression in MDX format.</Description>
<Template>STRTOTUPLE( «String Expression» )</Template>
</Function>
<Function>
<Name>STRTOVALUE</Name>
<Category>String</Category>
<Description>Returns a value from a string expression.</Description>
<Template>STRTOVALUE( «String Expression» )</Template>
</Function>
<Function>
<Name>SUBSET</Name>
<Category>Set</Category>
<Description>Returns a subset of members from a specified set.</Description>
<Template>SUBSET( «Set», «Start»[, «Count»] )</Template>
</Function>
<Function>
<Name>SUM</Name>
<Category>Statistical</Category>
<Description>Returns the sum of a numeric expression evaluated over a specified set.</Description>
<Template>SUM( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>TAIL</Name>
<Category>Set</Category>
<Description>Returns a subset of members from the end of a specified set.</Description>
<Template>TAIL( «Set»[, «Count»] )</Template>
</Function>
<Function>
<Name>TOGGLEDRILLSTATE</Name>
<Category>UI</Category>
<Description>Toggles the drill state of members.</Description>
<Template>TOGGLEDRILLSTATE( «Set1», «Set2»[, RECURSIVE] )</Template>
</Function>
<Function>
<Name>TOPCOUNT</Name>
<Category>Set</Category>
<Description>Returns a specified number of items from the topmost members of a specified set, optionally ordering the set first.</Description>
<Template>TOPCOUNT( «Set», «Count»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>TOPPERCENT</Name>
<Category>Set</Category>
<Description>Sorts a set and returns the topmost elements whose cumulative total is at least a specified percentage.</Description>
<Template>TOPPERCENT( «Set», «Percentage», «Numeric Expression» )</Template>
</Function>
<Function>
<Name>TOPSUM</Name>
<Category>Set</Category>
<Description>Sorts a set and returns the topmost elements whose cumulative total is at least a specified value.</Description>
<Template>TOPSUM( «Set», «Value», «Numeric Expression» )</Template>
</Function>
<Function>
<Name>TUPLETOSTR</Name>
<Category>String</Category>
<Description>Returns a string in MDX format from a specified tuple.</Description>
<Template>TUPLETOSTR( «Tuple» )</Template>
</Function>
<Function>
<Name>UNION</Name>
<Category>Set</Category>
<Description>Returns a set generated by the union of two sets, optionally retaining duplicate members.</Description>
<Template>UNION( «Set1», «Set2»[, ALL] )</Template>
</Function>
<Function>
<Name>UNIQUENAME</Name>
<Category>Metadata</Category>
<Description>Returns the unique name of a specified hierarchy.</Description>
<Template>«Hierarchy».UNIQUENAME</Template>
</Function>
<Function>
<Name>UNIQUENAME</Name>
<Category>Metadata</Category>
<Description>Returns the unique name of a specified member.</Description>
<Template>«Member».UNIQUENAME</Template>
</Function>
<Function>
<Name>UNIQUENAME</Name>
<Category>Metadata</Category>
<Description>Returns the unique name of a specified level.</Description>
<Template>«Level».UNIQUENAME</Template>
</Function>
<Function>
<Name>UNKNOWNMEMBER</Name>
<Category>Navigation</Category>
<Description>Returns the domain name and user name of the current connection.</Description>
<Template>UNKNOWNMEMBER</Template>
</Function>
<Function>
<Name>UNORDER</Name>
<Category>Set</Category>
<Description>Returns a set without ordering.</Description>
<Template>UNORDER( «Set» )</Template>
</Function>
<Function>
<Name>VALIDMEASURE</Name>
<Category>Value</Category>
<Description>Returns a value computed at the granularity of the measure group without unrelated dimensions and/or attributes.</Description>
<Template>VALIDMEASURE( «Tuple» )</Template>
</Function>
<Function>
<Name>VALUE</Name>
<Category>Value</Category>
<Description>Returns the value of a specified member.</Description>
<Template>«Tuple».VALUE</Template>
</Function>
<Function>
<Name>VAR</Name>
<Category>Statistical</Category>
<Description>Returns the variance of a numeric expression evaluated over a set, using an unbiased population.</Description>
<Template>VAR( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>VARIANCE</Name>
<Category>Statistical</Category>
<Description>Returns the variance of a numeric expression evaluated over a set, using an unbiased population. (Alias for Var function.)</Description>
<Template>VARIANCE( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>VARIANCEP</Name>
<Category>Statistical</Category>
<Description>Returns the variance of a numeric expression evaluated over a set, using a biased population. (Alias for VarP function.)</Description>
<Template>VARIANCEP( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>VARP</Name>
<Category>Statistical</Category>
<Description>Returns the variance of a numeric expression evaluated over a set, using a biased population.</Description>
<Template>VARP( «Set»[, «Numeric Expression»] )</Template>
</Function>
<Function>
<Name>VISUALTOTALS</Name>
<Category>Statistical</Category>
<Description>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 result set.</Description>
<Template>VISUALTOTALS( «Set», «Pattern» )</Template>
</Function>
<Function>
<Name>WTD</Name>
<Category>Time</Category>
<Description>Returns a set of members from the Week level in a Time dimension starting with the first period and ending with a specified member.</Description>
<Template>WTD( [«Member»] )</Template>
</Function>
<Function>
<Name>YTD</Name>
<Category>Time</Category>
<Description>Returns a set of members from the Year level in a Time dimension starting with the first period and ending with a specified member.</Description>
<Template>YTD( [«Member»] )</Template>
</Function>
</MDXFunctions>