Support for Microsoft-defined MDX expressions and functions:

TM1 supports the following Microsoft-defined MDX expressions and functions. Cognos TM1 implementation of these functions and expressions is based on the definitions in the Microsoft MSDN library, which is available at http://msdn.microsoft.com/library/

• List of Supported Member expressions
• List of Supported Member functions
• List of Supported Numeric functions
• List of Supported Set expressions
• List of Supported Set functions
• List of Supported Tuple expressions

List of Supported Member expressions:

• (dimension).CURRENTMEMBER
• (member).FIRSTCHILD
• (member).FIRSTSIBLING
• (member).LAG
• (member).LASTCHILD
• (member).LASTSIBLING
• (member).LEAD
• (member).NEXTMEMBER
• (member).PARENT
• (member).PREVMEMBER

List of Supported Member functions :

• ANCESTOR(...)
• COUSIN(...)
• OPENINGPERIOD(...)
• PARALLELPERIOD(...)

List of Supported Numeric functions :

• AGGREGATE(...)
• AVG(...)
• CORRELATION(...)
• COUNT(...)
• COVARIANCE(...)
• LINREGINTERCEPT(...)
• LINREGPOINT(...)
• LINREGR2(...)
• LINREGSLOPE(...)
• LINREGVARIANCE(...)
• MAX(...)
• MEDIAN(...)
• MIN(...)
• RANK(...)
• STDDEV(...)
• SUM(...)
• VAR(...)

List of Supported Set expressions :

• (dimension).MEMBERS
• (level).MEMBERS
• (member). CHILDREN
• (member).SIBLINGS

List of Supported Set functions :

• ADDCALCULATEDMEMBERS(...)
• BOTTOMCOUNT(...)
• BOTTOMPERCENT(...)
• BOTTOMSUM(...)
• CROSSJOIN(...)
• DESCENDANTS(...)
• DISTINCT(...)
• DRILLDOWNLEVEL(...)
• DRILLDOWNLEVELBOTTOM(...)
• DRILLDOWNLEVELTOP(...)
• DRILLDOWNMEMBER(...)
• DRILLDOWNMEMBERBOTTOM(...)
• DRILLDOWNMEMBERTOP(...)
• DRILLUPMEMBER(...)
• DRILLUPLEVEL(...)
• EXCEPT(...)
• EXTRACT(...)
• FILTER(...)
• GENERATE(...)
• HEAD(...)
• HIERARCHIZE(...)
• INTERSECT(...)
• LASTPERIODS(...)
• ORDER(...)
• PERIODSTODATE(...)
• TOPCOUNT(...)
• TOGGLEDRILLSTATE(...)
• TOPPERCENT(...)
• TOPSUM(...)
• SUBSET(...)
• UNION(...)

List of Supported Tuple expressions :

• (set).CURRENTMEMBER
• (set)[.ITEM](...)