Supported Set Functions

The following MDX set functions are supported.
  • 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(...)