Server IP : 180.180.241.3 / Your IP : 216.73.216.252 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>