DonatShell
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME SHELL ]     

Current File : C:/Program Files (x86)/Microsoft SQL Server/110/Tools/Templates/olap/1033/MDXFunctions.xml
<?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&gt;, «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>

Anon7 - 2022
AnonSec Team